Charlie,
Go to the select expert, click on show formula, formula editor, and
there type in not(isnull(<yourdatefield>)). Use appropriate conditions;
and, or etc... that's assuming you don't want to see null date fields,
if youre trying to bring on only date fields that are null drop the not
condition.
Rob Bucek
Manufacturing Engineer
PH: 715-284-5376 ext 311
FAX: 715-284-4084
<http://www.dsmfg.com/>
(Click the logo to view our site)
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Monday, April 06, 2009 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Compare date field to null Crystal
I need a report that I need to filter records that have a specific date
field that is null how can I set up this filter?
~Charlie
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Go to the select expert, click on show formula, formula editor, and
there type in not(isnull(<yourdatefield>)). Use appropriate conditions;
and, or etc... that's assuming you don't want to see null date fields,
if youre trying to bring on only date fields that are null drop the not
condition.
Rob Bucek
Manufacturing Engineer
PH: 715-284-5376 ext 311
FAX: 715-284-4084
<http://www.dsmfg.com/>
(Click the logo to view our site)
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Monday, April 06, 2009 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Compare date field to null Crystal
I need a report that I need to filter records that have a specific date
field that is null how can I set up this filter?
~Charlie
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]