Good day,
I have this Cancel Date "2018-11-06T00:00:00-05:00".
I would like to convert it into %Y%m%d%H%M%S (FME datetime) Format but as UTC time.
What is the best way to do so?
Solved
Conversion to UTC time
Best answer by takashi
Some FME Date/Time Functions could be used here effectively
e.g. assuming that attribute "_datetime" contains an ISO date/time with time zone suffix.
@TimeZoneRemove(@TimeZoneSet(@DateTimeParse(@Value(_datetime),ISO),utc))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.
- 7843 replies
- Best Answer
Some FME Date/Time Functions could be used here effectively
e.g. assuming that attribute "_datetime" contains an ISO date/time with time zone suffix.
@TimeZoneRemove(@TimeZoneSet(@DateTimeParse(@Value(_datetime),ISO),utc))Some FME Date/Time Functions could be used here effectively
e.g. assuming that attribute "_datetime" contains an ISO date/time with time zone suffix.
@TimeZoneRemove(@TimeZoneSet(@DateTimeParse(@Value(_datetime),ISO),utc))It's working. Great! Thanks!