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.
Change date format
Was this article helpful?
0 out of 0 found this helpful
Community
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 out of 0 found this helpful
Comments
7 comments
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.
Thank you. This only inform you that exported format date is wrong. In need change date like autocorrect function do with text.
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.
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
Hello,
You may do it as described above. With the help of “Date” type format and normalization.
Dear Ekaterina,
Thank you. Should I use Special content settings (not General) then?
Hello,
It is not necessarily. But please make sure that “May include month in words” check mark is enabled.
Please sign in to leave a comment.