Apr 15, 2002 #1 RushiShroff Programmer Joined Jan 23, 2002 Messages 216 Location IN How do you guys manage Null value insertion in field DateTime ? Rushi Shroff Rushi@emqube.com "Life is beautiful."
How do you guys manage Null value insertion in field DateTime ? Rushi Shroff Rushi@emqube.com "Life is beautiful."
Apr 15, 2002 #2 rkfox Programmer Joined Feb 15, 2002 Messages 26 Location US This seems to work for me: If LEN(Request.Form("AusApplicationDate") = 0 then ' if Blank set to NULL strSQL = strSQL & ", AusApplicationDate = " & "Null" & "" end if Upvote 0 Downvote
This seems to work for me: If LEN(Request.Form("AusApplicationDate") = 0 then ' if Blank set to NULL strSQL = strSQL & ", AusApplicationDate = " & "Null" & "" end if