コミュニティ

Change date format

Hello!

I would like to change exported date format from DD.MM.YYYY to YYYY-MM-DD. What is the easiest way to do that.

この記事は役に立ちましたか?

0人中0人がこの記事が役に立ったと言っています

コメント

7件のコメント

  • Avatar
    Permanently deleted user

    Hello,

    Please go to the field’s property > Open the Data tab > Press “edit” button in the data type section > Press “Set up” button > Select desired date format.

    0
  • Avatar
    Permanently deleted user

    Thank you. This only inform you that exported format date is wrong. In need change date like autocorrect function do with text.

    0
  • Avatar
    Permanently deleted user

    You can do this using normalization. If you open the Data Tab in the field properties and click on the normalization button at the bottom you should be able to set the Date Format you wish to use.

    2
  • Avatar
    Permanently deleted user

    Hi,

    we are facing the same problem with original document date format. For example - document says that date is 30JUN17. We are using normalization and date format is set to YYYY/MM/DD, it means that 30JUN17 must be exported as 2017/06/30 . How to do that?

    Thanks!

     

    Vaidas

    0
  • Avatar
    Permanently deleted user

    Hello,

    You may do it as described above. With the help of “Date” type format and normalization.

    0
  • Avatar
    Permanently deleted user

    Dear Ekaterina,

    Thank you. Should I use Special content settings (not General) then?

     

    0
  • Avatar
    Permanently deleted user

    Hello,

    It is not necessarily. But please make sure that “May include month in words” check mark is enabled.

    0

サインインしてコメントを残してください。