Need to extract date from DateTime field using FME but not working
The List Date in the bottom photo contains a field called ListDate which is stored in a SQL database.
We're using their WFS to download the data however due to the validation in Pro we can't see any date fields so we're using FME. I'm trying to use the transformer 'date time converter' but I get the prompts asking which fields I want & as you can see the software is splitting out 1 field into several which are all 'missing'. Which list elements should I select? Also in the select list elements box what number should be entered there? I just need the date so can strip out the time element.
We can't share the WFS as it's secure to our IP however we have now got the import working by resetting the defaults on the WFS incoming connection ? odd
The next issue is the dates are in an American format so I'm trying to use the date time converter to convert from the American format of Month Day Year Time to the English format of just Day, Month & Year without the time. I have tried several combinations but it keeps on giving me an error - any clues?
I have the date time converter working & have set the setting 'passthrough nulls' to Yes but there are 6 records below which have the FME rejection code INVALID_INPUT but these are genuine records just without a date. Any ideas?
DateTimeCoverter does not have ConditionalValue option. So you could either use a TestFilter before your DateTimeConverter transformer and have multiple data converters for each condition or you could use an AttributeManager where you can use a Conditional Value option and a DateTime Format function to use in the Text Editor.
