I have a report the date won't display. don't know why
@lastrundate - a parameter in date type YYMD in web focus STWK3/A8YYMD =&LASTRUNDATE; STWK4/MDYY=STWK3;
STWK4 should display 07/18/2014. but it won't display anything. can anyone see what is wrong?
thanks
GraceThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 7.6 Windows, All Outputs
September 18, 2014, 02:55 PM
Francis Mariani
quote:
A8YYMD
A8YYMD means alpha, so try
STWK3/A8YYMD ='&LASTRUNDATE';
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
September 18, 2014, 03:06 PM
Jing grace
I tried as'&lastrundate' . not working
&lastrundate was pulled from SQL table. the report worked well untill I updated the lastrundate in SQL date type from Datetime to Date. then the date stop displaying. in web focus metadata. the date type is YYMD. does the udpate in SQl can casue that?
WebFOCUS 7.6 Windows, All Outputs
September 19, 2014, 07:33 AM
MartinY
Update your master file, since you've changed the source definition (SQL), your master may not be accurate. Then you'll be able to adjust your defines accordingly.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
September 19, 2014, 10:29 AM
Jing grace
My master file was updated. the werid thing is if I do STWK3/YYMD =&LASTRUNDATE; STWK4/YYMD=STWK3; then I got 1901/03/12- which should be 2014-07/11, if I do STWK3/A8YYMD. I got nothing. it is really frustrating......
WebFOCUS 7.6 Windows, All Outputs
September 19, 2014, 10:33 AM
Jing grace
Never mind. I got it thanks all for helping
WebFOCUS 7.6 Windows, All Outputs
September 19, 2014, 10:33 AM
MartinY
What is &LASTRUNDATE value ?
Do -TYPE &LASTRUNDATE -EXIT
To see its value when returned from SQL.
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007