Skip to main content
Question

Published parameters and date range filter

  • February 8, 2023
  • 1 reply
  • 56 views

nicholas
Contributor
Forum|alt.badge.img+11

I have a workbench with two public parameters, start_date and end_date

I want to filter records on a date attribute. Values like "20220509213856"

Except, I want the actual range to be two days before the chosen start_date and two days after the chosen end_date.

How do I set up the Tester?

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+49

You can use a DateTimeCalculator to calculate the new start and end dates, then use a Tester to see if the date attribute is higher than the start date and lower than the end date. This particular date/time notation has the benefit of being a number, so you can do regular math on it.


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