Home > Archive > Visual Basic Crystal Reports > May 2005 > How do I test for a DateTime field that is null?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do I test for a DateTime field that is null?
|
|
|
| Hi, I've created a dataset as a source for Crytal report. Depending on the
user input there are 3 DateTime fields might or might not get data in it. In
Crystal I need to test these 3 fields. If no date/value in these fields then
certain action will take place. I tried using ISNULL and it doesn't work.
Does anyone know how to do this?
Many thanks in advance,
Alpha
| |
| Phil Hellmuth 2005-05-13, 4:22 pm |
| Alpha wrote:
> Hi, I've created a dataset as a source for Crytal report. Depending on the
> user input there are 3 DateTime fields might or might not get data in it. In
> Crystal I need to test these 3 fields. If no date/value in these fields then
> certain action will take place. I tried using ISNULL and it doesn't work.
> Does anyone know how to do this?
> Many thanks in advance,
> Alpha
>
Click on 'File....', 'Report Options...' and uncheck 'Convert NULL Field
Value to Default'.
| |
|
| That was already unchecked. I think the datetime field doesn't allow null.
I've setup a couple of flags to passed into Crystal to indicate if user
provided input or not to resolve this. Thanks for your help.
Alpha
"Phil Hellmuth" wrote:
> Alpha wrote:
>
> Click on 'File....', 'Report Options...' and uncheck 'Convert NULL Field
> Value to Default'.
>
| |
|
| Try the following:
Check 'Convert NULL Field Value to Default' and test for DateTimeField =
DateTime(0,0,0)
Or DateTimeField = DateTime(0,0,0,0,0,0)
Regards,
Jan
"Alpha" <Alpha@discussions.microsoft.com> schreef in bericht
news:007C4161-22B9-4E1A-A66B-B3BBBB6E5259@microsoft.com...
> Hi, I've created a dataset as a source for Crytal report. Depending on
the
> user input there are 3 DateTime fields might or might not get data in it.
In
> Crystal I need to test these 3 fields. If no date/value in these fields
then
> certain action will take place. I tried using ISNULL and it doesn't work.
> Does anyone know how to do this?
> Many thanks in advance,
> Alpha
>
|
|
|
|
|