date string-drop downs

Hi can anyone help me???:mad:

I have a form to input details into the databse. I have date posted and end date in drop downs, daay month year. (works fine locally)

Due to sql it wont work just getting 0000000, I need to put the 3 values into one date string and then convert it to Year-Month-Day can anyone tell me how to do this the one date string is really getting me, please if you can help tell me were to put the code as i am very new to this.

thanks

Not sure if this will work but you could try:

idate = CDate(Request.Form("Year") & "-" & Request.Form("Month") & "-" & Request.Form("Day"))

Also, make sure the page which inserts the date into the database has the correct Session.LCID

thanks, what is the correct Session.LCID?? I dont know what this is (sorry very new to this)

I finaly got it to work, i used a calender pop up and converted the date to yyyy/mm/dd.