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     [CLOSED] if date val EQ '01/01/1900' then display null
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] if date val EQ '01/01/1900' then display null
 Login/Join
 
Gold member
posted
Hi

i have date field in this formate(mdyy) from DB2 database


date_val(mdyy) formate
01/01/1900
03/21/2012
12/31/2011
01/01/1900
02/31/2011
01/06/2010

i want to display null when date_val is "01/01/1900"


date_val(mdyy) formate
null
03/21/2012
12/31/2011
null
02/31/2011
01/06/2010

can any one suggest me how to do plz

Thanks
kumar.

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


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 51 | Registered: December 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
DT_FLD/MDYY MISSING ON = IF DT_FLD EQ '01/01/1900' THEN MISSING ELSE DT_FLD;


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You might need to add this to atturhari's suggestion:

SET NODATA = 'null'

Alternatively, you could convert your date to an alpha value in order to display 'null' where appropriate:

NEWDATE/A10 = IF (ORIGINAL_DATE EQ '01/01/1900') THEN 'null' ELSE DATETRAN(ORIGINAL_DATE,'(MDYY)','(/)','EN',10,'A10');


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] if date val EQ '01/01/1900' then display null

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