comparing dates X, Y when X or Y could sometimes be blank

[kev510]

Hello everyone,
I am trying to compare two dates while one of them could sometimes be blank. One date is stored in a table as smalldatetime, and the other will be entered in mm/dd/yyyy format in a text box.

I want an action to occur if the date are different (1/1/2000 compared to 5/5/2005), or when comparing one null to an actual date (example: NULL in the table, 1/1/2000 in the text box)

I tried using many functions, and they all cause an error when one value is null. Thanks for your time!

 

[EBGreen]

Did you try the IsNull function?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[kev510]

IsNull?
How and where would I use that?
(I'm a newbie programmer, can you tell?)

 

[mrmovie]

If Not IsNull(datStart) Then

End If

same thing when looping through recordset stuff

If IsVariant()