Date format in asp

[Guest Saima01]

hi....i have designed a form with some date fields on it. The format that i've defined for date is "dd-mon-yyyy". Now what i want to do is whenever the form is submitted, the values that are to be stored in the database should be of "yyyy/mm/dd" format. i just browsed the web for a solution but couldn't get one till now. Any ideas of how can i do it?

[sorex]

I guess you'll make your life easier with the dd-mm-yyyy format, then it's justfdate=request("formdate")mydate=right(fdate,4)&"/"&mid(fdate,4,3)&"/"&left(fdate,2)or split it up which is even better en more secure