Insert Date into Database

Hello,

I have three dropdowns on a form: Month, Day, Year. I want to
combine the three and insert them into one database field.

BirthDate = Request.Form("Year") + "/" + Request.Form("Month") + "/" +
Request.Form("Day")

How do I pass the BirthDate string into the MM_fieldsStr ? What I
have below doesn't currently work.

Thanks !

Code:

If (CStr(Request("MM_insert")) = "PatientDemographics") Then

BirthDate = Request.Form("Year") + "/" + Request.Form("Month") + "/" +
Request.Form("Day")

MM_editConnection = MM_CTDB_Secure_STRING
MM_editTable = "dbo.tblPatientDemographics"
MM_fieldsStr = "" + BirthDate +
"|value|PatientID|value|SubmittedBy|value|Submitte dDTS|value|ModBy|value|ModDTS|value|Age|value|Sex| value|Height|value|Weight|value|Race|value|Race_Ot her|value"
MM_columnsStr = "BirthDate|',none,DEFAULT|FK_PatientID|',none,''|S ubmittedBy|',none,''|SubmittedDTS|',none,NULL|ModB y|',none,''|ModDTS|',none,NULL|Age|none,none,NULL| Sex|',none,''|Height|none,none,NULL|Weight|none,no ne,NULL|Race|',none,''|RaceOther|',none,''"

.oO(cwwilly)

I have three dropdowns on a form: Month, Day, Year.

That's bad. Why not do it in a more usable way - a simple input line and
a server-side script for parsing the input? Would make your visitors
very happy ...

Micha

Instead of a server-side script to parse, how about a validation control?