3 Replies Latest reply on Jan 11, 2016 11:27 PM by user19752

    Time import

    MikeWile

      I have a solution that I export time from. Looking at the exported file in Excel, everything looks as it should. Times are shown in 24-hour format.

       

      When I import the times into another solution, everything before noon come in correctly but anything after noon shows as question mark. Both fields are formatted the same in the solution. Any thoughts on why the difference.

       

      While on the subject of time, what is the difference between short system time and long system time? I've looked in all the FileMaker books including FileMaker Functions Reference but can't find anything.