date check problem

[partizan82]

How do i check if variable's value is zero for date type?

i tried this but it does not work:

if me!DateFromControl.value <> 0 then
blah... blah...
end if

gives me an error... Please help.. any suggestions will be appreciated. Thanks.

 

[RichMorrison]

Try this:

If (IsDate(me![DateFromControl]) Then
' it is a valid date
Else
' it is not a valid date
End If

RichM

 

[partizan82]

Thanks, i already found an answer... zero value for date type is #12:00:00 AM#... that's all i needed to know basically... and my query works now....!!!

thanks anyway