Importing dates from Excel to 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. The field type is Data.
I am having the same trouble trying to import time into FMP