Skip to main content
Solved

DateTime Conversion from character field to proper UTC Time

  • March 4, 2025
  • 1 reply
  • 39 views

arcvancouver
Contributor
Forum|alt.badge.img+19

Hi all. I am reading in an Excel sheet where DateTimeUTC is formatted like this as text, but I need to convert this into a proper datetime for UTC… thoughts? DateTimeConverter is out, or perhaps I’ve not formatted it correctly.   Otherwise, I can use attribute splitter to get the date, but the time part is tricky… not sure what to use to get that formatted properly

Best answer by arcvancouver

Ahhhh shoot… My google-fu wasn’t quite working out today. Saw this post and twigged on how to fix my issue with DateTimeConverter properly…

 

 

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.

1 reply

arcvancouver
Contributor
Forum|alt.badge.img+19
  • Author
  • Contributor
  • Best Answer
  • March 4, 2025

Ahhhh shoot… My google-fu wasn’t quite working out today. Saw this post and twigged on how to fix my issue with DateTimeConverter properly…