![]() |
||||||||||||
Go ![]() | New ![]() | Search ![]() | Notify ![]() | Tools ![]() | Reply ![]() | ![]() |
Silver Member |
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? thanksThis message has been edited. Last edited by: <Kathryn Henning>, WebFOCUS 7.6 Windows, All Outputs | ||
|
Expert |
See Compute Last Month's date in Dialogue Manager and also Simplifying the use of Date functions in Dialogue Manager Francis ![]() Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
Silver Member |
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 WebFOCUS 7.6 Windows, All Outputs | |||
|
Expert |
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 Francis ![]() Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
Silver Member |
It worked. thank you so much Frnacis. you are truely an expert! WebFOCUS 7.6 Windows, All Outputs | |||
|
Powered by Social Strata |
![]() | Please Wait. Your request is being processed... |
|