help in date format

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

in the processing page:

Code:

---

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

---

for access, use

Code:

---

#

---

for sql server, use

Code:

---

'

---