Skip to main content
Solved

Date string invalid format

  • December 16, 2022
  • 3 replies
  • 133 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

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.

3 replies

thijsknapen
Contributor
Forum|alt.badge.img+11
  • 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+46
  • 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.