-SET &ECHO=ALL;
SET LINES=999999
SET WEEKFIRST = 2
SET WEEKFIRST = ISO2

DEFINE FILE CAR
TDATE1/YYMD='20020525';
HDATE1/HYYMDIA = HDTTM(TDATE1, 8, 'HYYMDIA');
ADATE1/A10 = HYYWD(HDATE1, 'A10');
TDATE2/YYMD='20020526';
HDATE2/HYYMDIA = HDTTM(TDATE2, 8, 'HYYMDIA');
ADATE2/A10 = HYYWD(HDATE2, 'A10');
TDATE3/YYMD='20020527';
HDATE3/HYYMDIA = HDTTM(TDATE3, 8, 'HYYMDIA');
ADATE3/A10 = HYYWD(HDATE3, 'A10');

END
TABLE FILE CAR
PRINT CAR COUNTRY TDATE1 TDATE2 TDATE3
ADATE1 ADATE2 ADATE3
END
-EXIT



I am working on WebFOCUS 7611 Server64bit and when I run the above query I get the ADATE2 as blank column.

I observed that the above function HYYWD is not giving correct value for some specific dates only. Following are few examples for which this function is not working.
2006/02/06 ,2006/07/18 ,2006/12/30 ,2007/07/02 ,2007/12/14 ,2008/04/30 ,2009/04/14 ,2009/09/26 ,2010/09/10 ,2011/01/26 ,2002/05/26 ,2003/05/10 ,2003/10/22 ,2004/10/06 ,2005/02/22 ,2012/01/10 ,2012/06/22 .

Please help me why this function is not woking on these dates only.

This message has been edited. Last edited by: Ahamed Thaha,

This was a known issue and was fixed in 7.6.12 and 7.7*.

I have tried in 7.703 and it works correctly.

Hi,
Using your code with TDATE3=2006/02/06, I get:

COUNTRY     TDATE3      HDATE3              ADATE3                            
-------     ------      ------              ------     
ENGLAND     2006/02/06  2006/02/06 12:00AM  2006-W05-3

I'm using 7703 64-bit