I have a &lastrundate. I need to have another parameter &lastrundatestart 6 days before the &lastrundate.
&lastrundatestart=&lastrundate-6

I way I wrote it did not work. does anyone know how to do this with parameter?

thanks

This message has been edited. Last edited by: <Kathryn Henning>,

See Compute Last Month's date in Dialogue Manager and also Simplifying the use of Date functions in Dialogue Manager

My lastrundate is already data format I wanted. I don't see why I need to convert it again.
I tried below code:
-SET &LASTRUNDATESTART = DATEADD(&LASTRUNDATE2, 'WD', -6);

I got the result of 41464- not a date.
does the dateadd can't work with parameter?

grace

Your Dialogue Manager variable may looook like a date, but it's a simple text string. If you want to use Date functions with a Dialogue manager string, you need to convert it to a date format before using the date function. The links I provided explain this and show you how to do it.

-SET &lastrundate = '20140604';
-SET &lastrundatestart = DATECVT(DATEADD(DATECVT(&lastrundate,'I8YYMD','YYMD'),'D', -6), 'YYMD','I8YYMD');
-? &lastrun

It worked. thank you so much Frnacis. you are truely an expert!