AnsweredAssumed Answered

Time import

Question asked by MikeWile on Jan 8, 2016
Latest reply on Jan 11, 2016 by user19752

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.