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
  • 55 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.

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

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+49
  • 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.


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