As a workaround, a combination of a calculation and filter can be used to achieve this.
As an example, to report on records where PABI_COST_ALLOCATIONS.END_DATE is null or greater than sysdate, first create the below calculation:
CASE WHEN PABI_COST_ALLOCATIONS.END_DATE > sysdate
PABI_COST_ALLOCATIONS.END_DATE is NULL THEN 'Y' ELSE 'N' END
This calculation returns Y if end date is null or if the end date is greater than sysdate. All other results return N.
Next, create a filter = Y
Create a date filter using SYSDATE syntax
When creating filters in Insight using columns with the data type date, a date needs to be selected from a date picker and consequently, it isn't possible to use sysdate e.g. Date Left, sysdate.
J
Written by Joshua Shooter
Updated over a month ago