Hi, I have been using this to get data between system date and 5 days through sql statement select * from Table where date BETWEEN SYSDATE -&days AND SYSDATE days is initialized to 5 Now, Instead of SYSDATE, i need to use my own date already preset in dataset called FL_DT . I am passing FL_DT as a macro variable select * from Table where date BETWEEN &FL_DT -&days AND &FL_DT It is in Date9 format and i need to reduce 5 days from it in the same sql format as above. Could it be possible?
... View more