Skip to main content
Hi,

 

I'm using FME workbench 2013. I want to test based on a date field to filter out just those records that were entered into the database after a specifc date, how can I do this? I used a date formater to get the date in the format I want and then tried using a tester  > 13/09/2006, but that does not work. Any ideas?

 

Helen
HI Helen,

 

 

In the workflow, a date is treated as just a character string. I think if you format the date string into 'YYYYmmdd' form (8 digits), then all is going well.

 

For example, 20060913 < 20130625 is true.

 

 

Takashi
Hi,

 

 

I would query the database to return only features created after the date.

 

 

Itay
Yeah, querying might be more efficient than filtering by a Tester. As supplementation to Itay's suggestion: for querying to a database, you can use the SQLCreator or the SQLExecutor transformer. Alternatively, specifying the "WHERE Clause" parameter of the reader also can be available to get the same result as an SQL statement with a where clause.

 

 

Takashi

Reply