Thanks a lot for your helpful reply Stefan.
Actually I was trying to figure out the max date and have also used that to compare with the latest_update_date
the where clause is like this
FROM Table1 where (Date(Date#((Left([Datefield],18)),'DD-MMM-YY hh.mm.ss'),'DD-MMM-YY hh.mm.ss'))> $(last_Updated_Date) ;
but the script is not able to compare and throwing error.
the last updated date field snippet is as below
max(Date(Date#((Left([Datefield],18)),'DD-MMM-YY hh.mm.ss'),'DD-MMM-YY hh.mm.ss')) as MaxDate
let last_Updated_Date= Peek('MaxDate',0,'Last_Updated_Date');
If I hardcode the date the script is working.Can you help me to figure what I am doing wrong.