Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date value NULL and Access-2000/97

Status
Not open for further replies.
RushiShroff

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."
 
Sort by date Sort by votes
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
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
723
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question Question
First execute an input command and only then proceed with displaying the next record of the table
Replies
0
Views
637
leifoet
leifoet
leifoet
  • Locked
  • Question Question
How to display an existing date in Input type="date"?
Replies
4
Views
589
leifoet
leifoet
leifoet
  • Locked
  • Question Question
Using date picker gives an error message, only at application start
Replies
1
Views
780
MarkSweetland
MarkSweetland
JScannell
  • Locked
  • Question Question
Border issue with Google Chrome on an Android phone
Replies
0
Views
747
JScannell
JScannell

Part and Inventory Search

Sponsor

Back
Top