General discussion

Locked

Evaluating Oracle Null Date in Crystal

By SpiderDad ·
I am using Crystal Reports in Visual Studio 2003.
I am unable to evaluate a null date/time in a formula field. All I want to do is :
If date is null
then "No"
else "Yes";
My unsuccessful attempts :
1. "Is Null" errors out looking for a "Then" even though I have one.
2. I tried converting the date to text and checking if it's length > 0.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by emargel In reply to Evaluating Oracle Null Da ...

I am not familiar with Crystal but I have run into this issue with MS Access. In Access my code would look like this.

if isnull(date) then
"NO"
else
"YES"
end if

In your code if Crystal supports the term 'if date is null' I would try moving 'then' onto the same line otherwise check if you are using the correct syntax to determine if the date is a null value.

Collapse -

by SpiderDad In reply to

Poster rated this answer.

Collapse -

by SpiderDad In reply to Evaluating Oracle Null Da ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums