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.
Userlevel 1
+12
- Contributor
- 220 replies
-
25 September 2016
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.