Skip to main content
  • EN

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. 

ListDatelist of fieldslist elementsextra columns

Based on the screenshots you added the attribute containing DateTime is called ListDate,

Not ListDate.something. FME interprets a dot as a list defining character and displays "list" elements hierarchically.

Attribute vs List

ok - thanks 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.

ok - thanks 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. 

I believe you have a double space between month and day of month for strings containing single digit months (1-9). Just put a StringReplacer in front of DateTimeConverter to replace double space with single space

"  "-> " "

After replacing, %b %e %Y %H:%M%p as input should work

I believe you have a double space between month and day of month for strings containing single digit months (1-9). Just put a StringReplacer in front of DateTimeConverter to replace double space with single space

"  "-> " "

After replacing, %b %e %Y %H:%M%p as input should work

So like the below? I need the output to be DD/MM/YYYY datetime2

I believe you have a double space between month and day of month for strings containing single digit months (1-9). Just put a StringReplacer in front of DateTimeConverter to replace double space with single space

"  "-> " "

After replacing, %b %e %Y %H:%M%p as input should work

No. In front of DateTimeConverter put a StringReplacer transformer.

Text to replace double space (press the space bar 2 times), Replacement text single space (press the space bar a single time).

StringReplacer double space

Thanks very much I would never have thought of that & it works 🙂

Thanks very much I would never have thought of that & it works 🙂

Glad to be of help

Reply


Community Stats

30,162
Posts
114,484
Replies
37,809
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.