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.
Question
Microsoft date format
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+23- Influencer
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
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.