Question

Published parameters and date range filter

  • 8 February 2023
  • 1 reply
  • 8 views

Badge +10

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

Userlevel 4
Badge +25

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