Web Development

Ask something
Discussion Locked

Evaluating Oracle Null Date in Crystal

0 helpful
3 replies

by spiderdad

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by emargel

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.

This discussion is closed to new replies.