Skip to main content
Solved

Filter data using a date field

  • December 10, 2024
  • 2 replies
  • 65 views

dilip
Contributor
Forum|alt.badge.img+2
  • Contributor

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.

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

2 replies

birgit
Influencer
Forum|alt.badge.img+16
  • 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.


dilip
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • December 13, 2024

Thank you :)


Reply


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