Skip to main content
Solved

JSON file with a field yourDateOfBirth with a UK date format (DD/MM/YYYY), DateTime Converter not Converting to US format

  • December 15, 2023
  • 1 reply
  • 67 views

cnorth
Contributor
Forum|alt.badge.img+1

in in FME Json Reader following,

{

"yourDateOfBirth":"15/08/1987"

}

become column yourDateOfBirth with a value of 15/08/1987, I need to convert to value 08/15/1987?

 

Thanks

Best answer by redgeographics

There is a known bug with the DateTimeConverter, if you select the attribute it needs to work on via the triangle menu it does not actually pick that attribute, but rather the literal text you see there (@Value etc etc), you need to select the attribute via the [...] button instead.

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

redgeographics
Celebrity
Forum|alt.badge.img+62
  • Celebrity
  • Best Answer
  • December 15, 2023

There is a known bug with the DateTimeConverter, if you select the attribute it needs to work on via the triangle menu it does not actually pick that attribute, but rather the literal text you see there (@Value etc etc), you need to select the attribute via the [...] button instead.