AnsweredAssumed Answered

Importing dates from Excel to FMP

Question asked by RishiTrikha on Sep 9, 2013
Latest reply on Sep 9, 2013 by philmodjunk


Importing dates from Excel to FMP

Your post

          I am trying to import a column of dates into FMP. I have chosen the field type as date and formatted it as MM/DD/YY using the inspector. I understand that in excel, the dates are formatted such that it counts the number of days since Jan 1, 1901. therefore when I try to import the dates into FMP, it shows up as the number of days in FMP. When I tried to change it into a date format, all dates showed up as 0/0/00. I need to show the dates so that I can calculate the difference between two different dates and have so many dates that it would take too long to enter it manually. The field type is Data.
          I am having the same trouble trying to import time into FMP