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))
+19- Contributor
- 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))takashi wrote:
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!
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.