+10I am trying to convert a three character month to a two digit month (e.g. - Mar to 03) using FME 2016.1 (build 16492). Should be easy enough using the DateFormatter but the converted value returned is always 01. I think my parameters are set up correctly. Screenshot attached. Any ideas?
Thanks,
Aaron
Best answer by ebygomm
I think the DateFormatter in 2016 only works on dates, so you can convert 01-Jan-2018 to 01-01-2018 but not just the Jan element on it's own.
There are a number of other ways to convert the months to their numeric values if it's just months with no day and year, e.g. attributevaluemapper
Or appending next in front of your 3 letter month and putting that through the date formatter using auto as the source will work too
+2Hi @aaron,
Not sure why the DateFormatter isn't giving you the correct output but it works with the DateConverter using the following parameters:
Here is a sample workspace: 2016.1_DateConverter.fmwt
+32I think the DateFormatter in 2016 only works on dates, so you can convert 01-Jan-2018 to 01-01-2018 but not just the Jan element on it's own.
There are a number of other ways to convert the months to their numeric values if it's just months with no day and year, e.g. attributevaluemapper
Or appending next in front of your 3 letter month and putting that through the date formatter using auto as the source will work too
+10Thanks @egomm and @ChrisAtSafe, both of your solutions work. I appreciate it!
Aaron
Hi @aaron,
Not sure why the DateFormatter isn't giving you the correct output but it works with the DateConverter using the following parameters:
Here is a sample workspace: 2016.1_DateConverter.fmwt
FYI, the images are broken...
+29An alternative solution would be to use the AttributeValueMapper.
This would be my choice for this kind of problem. But the DateConverter could be more robust because it can deal with oct,Oct,10,okt differentiations.
This would be my choice for this kind of problem. But the DateConverter could be more robust because it can deal with oct,Oct,10,okt differentiations.
Yes, it would absolutely depend on the input data.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
