Subscribe Bookmark RSS Feed

Filter by a differnce between two dates

dayvie

Community Trekker

Joined:

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

  Where(

   :Days to Last Modified >= :3: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...