US date field format
Does anyone know how to set up a field as US format? Not just the way it is displayed, but it needs to be exported in US format.
Actually, it's the number of days since 12/31/0000 (event the FileMaker Training Series book is off by one on this one.)
When exporting records, there's an option to "use current layout's data formatting when exporting". So if you use that option with a layout that specifies the desired date format, you should get the result that you need.
Internally, date fields are the number of days since Jan 1, 1900.
There is a default format and this is what is exported.
Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode > Specifying formats for date fields
You're a star!! Works perfectly :)
Retrieving data ...