topic Need to extract date from DateTime field using FME but not working in ArcGIS Data Interoperability Ques.

Need to extract date from DateTime field using FME but not working

AndrewReynoldsDevon — Wed, 03 May 2023 14:15:14 GMT

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.

Re: Need to extract date from DateTime field using FME but not working

RenatoSalvaleon3 — Wed, 03 May 2023 21:26:49 GMT

@AndrewReynoldsDevon is the WFS service public? Can you share the link?

Re: Need to extract date from DateTime field using FME but not working

AndrewReynoldsDevon — Thu, 04 May 2023 07:46:20 GMT

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?

Re: Need to extract date from DateTime field using FME but not working

AndrewReynoldsDevon — Thu, 04 May 2023 09:08:56 GMT

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?

Re: Need to extract date from DateTime field using FME but not working

AndrewReynoldsDevon — Thu, 04 May 2023 11:43:19 GMT

I have a new issue where the date time converter is rejecting single date formats which are 1-9. The dates from 10-31 are working ok or I can get 1-9 working with %b ?%e %Y however if I use the 2nd format it change all dates which are larger than 10 to single digits so need to build a else statement but am struggling.

Re: Need to extract date from DateTime field using FME but not working

RenatoSalvaleon3 — Thu, 04 May 2023 13:36:35 GMT

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.