Skip to main content
  • EN

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?

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


Community Stats

30,161
Posts
114,495
Replies
37,813
Members
Terms & ConditionsCookie 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.