AnsweredAssumed Answered

Format for importing dates from excel into FMP

Question asked by RishiTrikha on Sep 6, 2013
Latest reply on Nov 27, 2013 by philmodjunk


Format for importing dates from excel into FMP


     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.
     I am having the same trouble trying to import time into FMP