AnsweredAssumed Answered

Exporting dates into CSV: 2-digit not  4-digit year

Question asked by aikiko on Jan 3, 2012
Latest reply on Jan 6, 2012 by aikiko

Title

Exporting dates into CSV: 2-digit not  4-digit year

Post

Dear All,

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.

Kind regards

Aikiko

OSX 

FMP11

 

 

 

 

Outcomes