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
July 31, 2014, 10:09 AM
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?
WebFOCUS 7.6 Windows, All Outputs
July 31, 2014, 10:29 AM
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.