Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Date format result mismatch 8201M vs 8204M
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]Date format result mismatch 8201M vs 8204M
 Login/Join
 
Virtuoso
posted
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,


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2223 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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)?


WebFOCUS 8206, Unix, Windows
 
Posts: 1707 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Issue is that with gen 1337 of the RS there is a bug fixed from gen 1339 and above


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2223 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Date format result mismatch 8201M vs 8204M

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.