Exporting dates into CSV: 2-digit not 4-digit year
I have exported my FMP file as a CSV file but the years are in 2 digits, and I need them to be 4 digits to work in my anaylsis software, Stata.
I have checked and un-checked the "Apply current layout’s data formatting to exported data" option
In the options for the date field, I have already checked "Strict data type: 4 digit year date"
I have exported under the "Merge" option to make the CSV file.
If I export the FMP file as an Excel file, I will get the 4 digit year, then I can export it as a CSV file. However this will slow me down and is not so elegant.
Is this a CSV issue? Merge issue? Or am I missing something obvious? Thoughts appreciated.