Skip to main content
Solved

Date string invalid format

  • December 16, 2022
  • 3 replies
  • 90 views

townest
Contributor
Forum|alt.badge.img+4

Hello,

I have the following date string(s):

image.png...which I need to convert to datetime objects. They appear to be 'iso datetime with offset', however I continually get invalid format with auto detect or manual choosing format. I have tinkered with several other input formats to no avial.

 

imageAny ideas?

 

Thank you,

 

Tyler

FME Workbench 2022.1

Best answer by ebygomm

There is a bug with attribute selection in the DateTimeConverter

See here

https://community.safe.com/s/question/0D54Q00009tzKL5SAM/datetimeconverter-version-4-produces-invalidinput

As @thijsknapen​ says, if you correct this the transformer should run correctly

View original
Did this help you find an answer to your question?

3 replies

thijsknapen
Contributor
Forum|alt.badge.img+10
  • Contributor
  • December 16, 2022

I think your the input for your Datetime Attributes is at fault. Try changing from '@Value(date_in)' to 'date_in'.

The following seems to work for me;

image


ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • December 16, 2022

There is a bug with attribute selection in the DateTimeConverter

See here

https://community.safe.com/s/question/0D54Q00009tzKL5SAM/datetimeconverter-version-4-produces-invalidinput

As @thijsknapen​ says, if you correct this the transformer should run correctly


townest
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • December 16, 2022

Oy...I should have noticed that...too focused on the format string. Thx.


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