AnsweredAssumed Answered

Converting time twice from UTC

Question asked by TracyBogans on Feb 22, 2015
Latest reply on Feb 22, 2015 by philmodjunk

Title

Converting time twice from UTC

Post

I'm pulling information from a SQL database that is storing time as UTC  time. But when I import it into filemaker  it convert into a the incorrect Military time. When I see it in the SQL databse it shows and save as 14:18:26 UTC... when it gets to Filemaker it reads 2:15:26 ( which I thinking is military time but the org time of the time in UTC 14:18:26  which is 9:18:26 am EST and Military time should be the same... but filemaker coverts it to 14:18:26 which is 2:18:26 PM EST ...  I have tried importing  where I let filemaker create the fields and also I have try it where I create the field as all text field ... same result.

HELP

 

ConvertingTime.PNG

Outcomes