Has anyone else had issues with the DOWK function returning the wrong day of the week?
Is it a known issue?This message has been edited. Last edited by: <Kathryn Henning>,
May 21, 2014, 12:32 PM
jgelona
DOWK works just fine for us. Use it all the time.
What makes you think it is incorrect?
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
May 21, 2014, 01:05 PM
Francis Mariani
Please provide sample code.
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
May 21, 2014, 01:10 PM
Doug
Checkout the SETting for "BUSDAYS"
May 21, 2014, 01:14 PM
Francis Mariani
Today (2014/05/21) is Wednesday:
TABLE FILE CAR
SUM
SALES
COMPUTE TODAY/I8YYMD = &YYMD;
COMPUTE TODAY_DOWK/A4 = DOWK(TODAY, 'A4');
COMPUTE TODAY_DOWKL/A12 = DOWKL(TODAY, 'A12');
BY COUNTRY
WHERE RECORDLIMIT EQ 1
END
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
May 21, 2014, 08:53 PM
StuBouyer
Are you by chance using I6YMD dates?
You may need to tweak your DEFCENT and YRTHRESH values to make sure you are looking at the correct century.
SET YRTHRESH = 00
TABLE FILE CAR
SUM
SALES
COMPUTE TODAY/I6YMD = &YMD;
COMPUTE TODAY_DOWK/A4 = DOWK(TODAY, 'A4');
COMPUTE TODAY_DOWKL/A12 = DOWKL(TODAY, 'A12');
BY COUNTRY
WHERE RECORDLIMIT EQ 1
END
SET DEFCENT = 20
TABLE FILE CAR
SUM
SALES
COMPUTE TODAY/I6YMD = &YMD;
COMPUTE TODAY_DOWK/A4 = DOWK(TODAY, 'A4');
COMPUTE TODAY_DOWKL/A12 = DOWKL(TODAY, 'A12');
BY COUNTRY
WHERE RECORDLIMIT EQ 1
END
Cheers
StuThis message has been edited. Last edited by: StuBouyer,