Question:
How can I pass a date to a database using ASP?
Answer:
The answer depends on what database you are using. Say you are using a variable called ‘strDate’ to hold your date value. If you are using Access, build a string:
strSQL = " valid sql string " & "#" & strDate & "#"
If you are using SQL Server, Sybase, or Oracle, build a string:
strSQL = " valid sql string " & "'" & strDate & "'"
Note the difference is in the delimiters used for sending the date variable. Access uses the pound sign (#), the others use the singe quote (‘).