help in date format

[simi28]

Hi all
I have 3 drop down box for month date and year.
i need to concatenate the same like 11/22/2006 into one one variable so that
only date format should insert in databse.
how can i do the same?
Please help.
thanks

[dev.rogee]

in the processing page:

Dim sd
sd = Request.Form("bmonth") & "/" & Request.Form("bday") & "/" & Request.Form("byear")
strSQL = "INSERT INTO table " & _
        "(theDate) " & _
        "VALUES(#" & sd & "#)"

for access, use

#

for sql server, use

'