Skip to main content
  • EN

Hello everyone,

I'm working on a project in FME and need to filter date values from a CSV file. I have the following requirements:

  • The date should be between 01.01.2021 00:00 and 22.07.2021 23:59.
  • The date column is in the CSV file and is formatted as dd.MM.yyyy HH:mm.

I've tried using the DateTimeConverter and Tester transformers, but I'm not sure if I've configured everything correctly. Does anyone have tips or examples on how to implement this?

Thank you in advance!

I think you need to reformat the date to fme date using the DateTimeConverter (%d.%m.%Y %H:%M to %Y%m%d), then you can test if date is between 20210101 and 20210722.

 

Great @nielsgerrits 

Reply


Community Stats

30,142
Posts
114,414
Replies
37,784
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.