Subscribe Bookmark RSS Feed

Filter by a differnce between two dates


Community Trekker


Jan 21, 2014

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 ),


   :Days to Last Modified >= :3:06:40:08 & :Days to Last Modified <=



  Display( :Days to Last Modified, Size( 73, 16 ) )



works fine using the data filter, but not when I run it from a script...