That’s a feature we built in called ‘ongoing date’ support. Add the start date to the field list, then set the ongoing date field to the end date column name. Then enable the field to be filterable.
Hi Scott,
I’m sorry but how can I use this ‘ongoing date’ with a custom SQL?
thank’s in advanced
Be sure to select two columns, the first column being the starting date, the second column being the ending date. Then in the “Ongoing Date” option in the field set, you would set the starting date column name as the field, and the “Ongoing Date” option would be set to the ending date column.
