Joining three form fields (request.form) to insert into one SQL field 1

[timtom]

I've got three Select Boxes representing Day, Month and Year and I want them to go into one date field just as if I were inserting the actual date into a field. (i.e. 30/08/01) I know how to split form fields, but not sure how to join them. Any ideas?
Cheers
Sarah

[sub]WASN'T FIT ENOUGH FOR THE POLICE FORCE[/sub]​

 

[Extentec]

Try this, i'm not sure if it is applicable, post your code for more assistance:

dtInsertThisDate = Request.Form("selDay&quot & _
"/" & Request.Form("selMonth&quot & _
"/" & Request.Form("selYear&quot

dtInsertThisDate = Cdate(dtInsertThisDate)


i even got the dd/mm/yyyy in the correct order

http://www.onti.net

 

[kevink]

Hi Sarah,

If I follow the question correctly, you can just join the strings together:

E.g.

myDate = request.form("day") & "/" & request.form("month") & "/" request.form("year")

Just don't forget that VBSCript and Access generally stores the dates in mm/dd/yy format (may not worry you if you're in the US though!)

HTH,

Kevin

 

[Extentec]

kevink, Good point about the vbscript default...DO NOT use Cdate with my above solution if you have access set up for dd/mm/yyyy unless your IIS local is set properly also(may have to test).

http://www.onti.net

 

[timtom]

Cheers for the help both of you. Easy when you know how, huh?

Thanks again

Sarah

[sub]WASN'T FIT ENOUGH FOR THE POLICE FORCE[/sub]​