Datepicker: Null value not working in SQL

[Guest Tergniet]

I have syntex as follows

 

If datepicker.value = Null then

something

else

something

end if

 

The Null does not flow into following line when the value is Null of picker. Checked it when mouse pointer is hovered over datePicker.value. Goes to else line.

 

Any pointers

Thanks

[reboot]

Try:

 

If IsNull(datepicker.value) Then

[Derek Stone]

If DateTimePicker1.Value.Equals(Nothing) Then

[reboot]

eek! I'm in the .Net forum aren't I. Sorry. images/smilies/dismayed.gif

[Derek Stone]

We all do it reboot. I know I have. :)