Skip to main content
  • EN

Has any one used the Microsoft Date Format in FME.

I have a json object containing

"DateCreated" : "\\/Date(1461265817000-0400)\\/"

Which is apparently April 21, 2016, but I have no idea how to convert it.

Hi,

The date you have shown is a epoch date with timezone (have a look at

http://www.epochconverter.com/ for thorough details)

So it is %s in Dateformatter, for this portion

1461265817 (removing the last three zeros which are the milliseconds, and the timezone)

Cheers,

Todd

Reply


Community Stats

30,123
Posts
114,335
Replies
37,752
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.