Skip to main content
  • EN
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


Community Stats

30,162
Posts
114,481
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.