Skip to main content
Solved

How to Filter Date Values in FME?

  • October 30, 2024
  • 2 replies
  • 210 views
arash_hokm
Contributor
Forum|alt.badge.img+8

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.

 

View original
    Did this help you find an answer to your question?

    2 replies

    nielsgerrits
    VIP
    Forum|alt.badge.img+54
    • nielsgerritsVIP
    • Best Answer
    • 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.

     

    1 Attachments
    geomancer
    danilo_fme
    arash_hokm
    3 people upvoted this
    • geomancer
      geomancer
    • danilo_fme
      danilo_fme
    • arash_hokm
      arash_hokm
    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • October 31, 2024

    Great @nielsgerrits 

    Reply


    Helpful Members This Week

    Community Stats

    31,140
    Posts
    118,062
    Replies
    38,759
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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.