Skip to main content
Question

I have"year installed" values (1999, 2011, ...) in a CHARACTER field. I need to get that data into a "date installed" DATE field. Best would be YYYY only in the date field, but I could work with YYYY/D/M if necessary. Is that possible?


I have"year installed" values (1999, 2011, ...) in a CHARACTER field. I need to get that data into a "date installed" DATE field. Best would be YYYY only in the date field, but I could work with YYYY/D/M if necessary. Is that possible?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+54
  • Celebrity
  • February 17, 2021

You can use the date time converter to convert date formats. You'll need to see what date format(s) your output filetype accepts

Generally, when an attribute exists in workbench FME doesn't care whether its a string/char/int/float/date field. You can set the field type in the writerScreenshot 2021-02-18 081930


  • Author
  • February 17, 2021

Thanks for the reply.


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