Date fields and system formats

[Bob476]

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.

I've read several helpful posts on veryifying system formats on client machines accessing this from FM Server. What's weird is that I have checked this, and re-entered dates manually in correct format but they are still exporting incorrectly.

They look normal in Filemaker even when I do a raw table view. Help!!

[Lee Smith]

Hi Bob,

I don't work with served files, so take this with a grain of salt, but have tried using the option to export using the current layout format?

HTH

[SteveB]

Lee, I doubt that FM uses any layout to export data. It is strictly what the current export orderis or whats been saved in a script.

Steve

[Lee Smith]

In the export dialog box, you have the option to export using the format of the current layout.

Lee