1 Reply Latest reply on Sep 9, 2013 1:02 PM by philmodjunk

    Importing dates from Excel to FMP

    RishiTrikha

      Title

      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