Converting time twice from UTC
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.