Null date value inserts 1/1/1900 as date

IntercareSupport
IntercareSupport used Ask the Experts™
on
I have some ASP (vb) code that when I leave the date field blank, it defaults to 1/1/1900.  I have this code below that I would figure would work, but it doesn't.

This is not good.  I figured forcing a "null" date value might work (like below).  It doesn't.  Help.
If Request.Form("billing_follow_up_date") = "" then
	strSQL = strSQL & "'', "
else
	strSQL = strSQL & "'" & Request.Form("billing_follow_up_date") & "', "
End if

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
strSQL = strSQL & " NULL, "

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial