Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Null dates
 Login/Join
 
Tracie
Gold member
posted
How do I check to see if a date is null? I am doing a what if. I have if field = something and datefield is null. Thanks


WebFocus 7703
Windows 7
Output format: HTML, Excel, PDF
 
Posts: 54 | Registered: May 07, 2008Report This Post
Majid Jeddi
Guru
posted Hide Post
Hi Tracie,

If a field with a null value is retrieved, the field value is not used in aggregating calculations such as averaging and summing. If the report calls for the field's value to display, a special character appears to indicate a missing value. The default character is a period (.), but you can change it to any character string you wish using the SET NODATA command, as described in the doc

Regards


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
BarbaraA
Member
posted Hide Post
In a DEFINE or COMPUTE, you can do:

IF fieldname IS MISSING

and it will check for a null value.


WF Reporting Server 71x, 76x
 
Posts: 15 | Registered: September 10, 2007Report This Post
Leah
Virtuoso
posted Hide Post
What kind of data base are you reporting from. For example our dates in DB2 are all defined as 'NOT NULL' so they have a default date in them, which for DB2 I believe is 0001-01-01, our software vendor changes them all to 1001-01-01.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Tracie
Gold member
posted Hide Post
Thanks to all for the help. The "is missing" option is what I needed.


WebFocus 7703
Windows 7
Output format: HTML, Excel, PDF
 
Posts: 54 | Registered: May 07, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders