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.

 

Reply


Community Stats

29,979
Posts
113,899
Replies
37,610
Members
Terms & ConditionsCookie settings