help adding date to sql server

[georgecheyne]

Hi,

I'm trying to add a date (user specified) to my SQL server using an ASP page with drop down menus to select day, month and a text with 2 characters for year.
Then I have a string to put them together as one variable and I am trying to use the function fromatdatetime to get the date into a valid format for the db (using datetime datatype).
My problem lies in how to split up the date terms. If i use forward slash it divides the numbers and if i use colons or full stops it displays as time.
I've seen this method of collecting date info millions of times on other web pages but I can't get it to work.

my code:

dim start
dim startd
start = Request.Form ("startd") & "." & Request.Form ("startm") & "." & Request.Form ("starty")
startd = FormatDateTime(start,3)

where startd is an optionbox for day, startm an option for month and starty a 2 character textbox for year.

Thanks for any advice

[georgecheyne]

I've also tried stuff with single quotes ie:

start = "'" & Request.Form ("startd") & "." & Request.Form ("startm") & "." & Request.Form ("starty") & "'"

didn't work like this, with or without the formatdatetime function.

any other ideas?

[JasonGS]

Have you tried...

StartDate = Request("startd") & "/" & Request("startm") & "/" & Request("starty")

??????

PS: the .form dont matter, I was just lazy

[georgecheyne]

yeah I tried that but the "/" character meant that the numeric values entered for the dates all divided themselves into each other.
I have fixed it now by using ascii code to represent the "/" ie:
startdate = Request.Form ("startm") & chr(47) & Request.Form ("startd") & chr(47) & Request.Form ("starty")
This works but is a bit of a work round rather than pure solution.
Thanks for your input though,
George