Date field exporting format

By Bob476
May 21, 2003 in Importing & Exporting

Share

https://fmforums.com/topic/15744-date-field-exporting-format/

Followers 0

This topic is 7858 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Bob476

Posted May 21, 2003

In Filemaker, I have date fields set as "leave Date formatted as entered" which gives me data of mm//dd/yyyy no matter what format I view it in Filemaker.

However, recently, when I try to export and view in Excel, some of these dates are coming out as dd/mm/yy, so what is 06/21/2003 in filemaker appears as 21/06/20 in Excel.

Any clues? things I should be checking?

This topic is 7858 days old. Please don't post here. Open a new topic instead.