I have a data set with a column of dates. I am trying to filter the rows based on the difference between the existing date column and today. I can subtract the date from today() and use the data filter on the table, but when I try to use the script it never selects any rows.
This is the data filter script that I was using:
Current Data Table() << Data Filter(
Location( {2166, 239} ),
Add Filter(
columns( :Days to Last Modified ),
Where(
:Days to Last Modified >= 
:06:40:08 & :Days to Last Modified <=
:4:00:00:00
),
Display( :Days to Last Modified, Size( 73, 16 ) )
)
);
works fine using the data filter, but not when I run it from a script...
