AnsweredAssumed Answered

Imported Date Format Changes

Question asked by anthonydannunzio on Jan 19, 2011
Latest reply on Jan 19, 2011 by anthonydannunzio


Imported Date Format Changes


I have just started a FileMaker Pro trial. I am trying to set up a database by importing data from Excel files. Everything seems OK with one exception. Imported dates from Excel do not appear as they were in Excel nor as specified in FileMaker. For instance, the date 10/22/2010 in Excel appears as the number 40473 in FileMaker Pro and the date 10/28/2010 in Excel appears as 40479 in FileMaker Pro. I reviewed the cell definition in Excel and the data definition in Layout in FileMaker Pro and they seem to be correct and consistent but.... the data in the database is still incorrect. Probably some foolish oversight.

I uploaded a screen selection I took with Grab.

Thanks for whatever help you can provide.