what is the script to check if the date is 14 days after a particular date

[Ramprasaath]

'state=requested^group=NULL^source_table=std_change_proposal^due_dateONYesterday@javascript:gs.beginningOfYesterday()@javascript:gs.endOfYesterday()'

in the script above, there's a due date which checks for due date on yesterday.

i need it to check for any date 'Y' which is 14 days after a date 'X'.

how do i change that?

[Mike Patel]

try

state=requested^group=NULL^source_table=std_change_proposal^due_dateRELATIVEGT@dayofweek@ahead@14

[Ramprasaath]

but the 'dayofweek' u have mentioned here is not a date but another field on the table. so how to compare it with another colomn and check if the date 'X' is 14 days after the date in the colomn

[Mike Patel · Accepted solution]

you can build your own encoded query. use filters on example below