Hi,

Using below code in WF8201M vs WF8204M doesn't give the same result

-*-* With or without below SET the result is the same
SET DATEOUTPUT = LOCALIZED
DEFINE FILE GGSALES
DT_YYMD /YYMD = DATE;
DT_YYMM /YYM  = DT_YYMD;
END
TABLE FILE GGSALES
BY DATE
BY DT_YYMD
BY DT_YYMM
END
-RUN

-*-* Result with 8201M (partial)
Date       DT_YYMD    DT_YYMM 
1996/01/01 1996-01-01 1996/01 
1996/02/01 1996-02-01 1996/02 
1996/03/01 1996-03-01 1996/03 
1996/04/01 1996-04-01 1996/04 
1996/05/01 1996-05-01 1996/05 


-*-* Result with 8204M (partial)
Date       DT_YYMD    DT_YYMM 
1996/01/01 1996-01-01 1996-01 
1996/02/01 1996-02-01 1996-02 
1996/03/01 1996-03-01 1996-03 
1996/04/01 1996-04-01 1996-04 
1996/05/01 1996-05-01 1996-05 

Look at DT_YYMM where in first it's a "/" and second a "-"

I have compared both Client NLS settings and RS LOCALE settings, and they are the same

Language settings
On 8201M :
Client : 8.2.0.1M gen 240, NLS : 137 - US, DLS : en_US & fr_CA
RS : 82M gen 1107, NLS : 137 - U.S.

On 8204M :
Client : 8.2.04M gen 33, NLS : 137 - US, DLS : en_US & fr_CA
RS : 8203M gen 1337, NLS : 137 - U.S.


I have an open case, but asking to see if anybody have an idea

This message has been edited. Last edited by: MartinY,

I can't change my LOCALE or NLS. I'm running 8206. I just tested your code and I get all / for date separators.

Does this happen if you run this code on the Reporting Server (sans Client)?

Issue is that with gen 1337 of the RS there is a bug fixed from gen 1339 and above