Skip to main content
Solved

DateTime Conversion from character field to proper UTC Time

  • March 4, 2025
  • 1 reply
  • 21 views
arcvancouver
Contributor
Forum|alt.badge.img+9

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…

 

 

View original
siennaatsafe
tomf
bruceharold
19 people upvoted this
  • siennaatsafe
    siennaatsafe
  • tomf
    tomf
  • bruceharold
    bruceharold
  • nic_ran
    nic_ran
  • chriswilson
    chriswilson
  • J
    jamess
  • daztreg
    daztreg
  • simonl
    simonl
  • ekkischeffler
    ekkischeffler
  • fme-phile
    fme-phile
  • darkspatiallord
    darkspatiallord
  • stevenjh
    stevenjh
  • janrykr
    janrykr
  • ngoorman
    ngoorman
  • T
    teebs
  • S
    spatial_k
  • B
    bananaspn
  • M
    mickjwebb
  • C
    cillingworth81
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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+9
  • arcvancouverContributor
  • 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…

 

 

AliAtSafe
nielsgerrits
geomancer
6 people upvoted this
  • AliAtSafe
    AliAtSafe
  • nielsgerrits
    nielsgerrits
  • geomancer
    geomancer
  • danilo_fme
    danilo_fme
  • DanAtSafe
    DanAtSafe
  • liamfez
    liamfez

Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.