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!

Solved

How to Filter Date Values in FME?

Forum|Forum|1 year ago
October 30, 2024
2 replies
403 views

+8

arash_hokm
Contributor

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!

Best answer by nielsgerrits

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

+62

nielsgerrits
Best Answer
Forum|Forum|1 year ago
October 30, 2024

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.