Skip to main content
Solved

Filter data using a date field

  • December 10, 2024
  • 2 replies
  • 125 views
dilip
Contributor
Forum|alt.badge.img+5

I am looking to extract data from AGOL to store in a separate table and filter the data by its date field. Essentially I will schedule this every evening to collate all the data with todays date, or run this early morning and filter on ‘Yesterdays’ date. How do I configure the tester transformer to reflect what I need. 

 

Any help is greatly appreciated,

Best answer by birgit

I made an example for you. Basically you use the DateTimeCalculator to calculate yesterday. Then you say that your date needs to be higher then yesterday in the tester and you set the comparison mode in the tester to Date/Time.

    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.

    2 replies

    birgit
    Influencer
    Forum|alt.badge.img+22
    • birgitInfluencer
    • Influencer
    • Best Answer
    • December 10, 2024

    I made an example for you. Basically you use the DateTimeCalculator to calculate yesterday. Then you say that your date needs to be higher then yesterday in the tester and you set the comparison mode in the tester to Date/Time.

    1 Attachments
    🫠
    dilip
    liamfez
    dilip
    Contributor
    Forum|alt.badge.img+5
    • dilipContributor
    • Author
    • Contributor
    • December 13, 2024

    Thank you :)

    Community Stats

    32,154
    Posts
    122,043
    Replies
    39,812
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.