Solved

Date string invalid format

  • 16 December 2022
  • 3 replies
  • 19 views

Badge +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

icon

Best answer by ebygomm 16 December 2022, 12:30

View original

3 replies

Badge +3

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

Userlevel 1
Badge +21

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

Badge +4

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

Reply