Hi All,

I have one requirement ,like If an employee is terminated Today this employee has to send to Output file forperiod of 30 days ,after 30 days employee should drop of the file.

I have written the code in SQR like below
let $date1=dateadd(datenow(),'Day',30)
if $Current-date<=$date1
Let $write-flag1='Y'
end-if
but this SQR will run every day so the value of the Datenow() function will vary every day.so it is not working as per the above code
can any one Guide me How to Put condition from current date to 30 days in the SQR

Thanks in advance
suma