Combine fields and insert into a database. 2

[ahksar]

Hi,
I have 3 pull down menus for a user to select a date, and I want to put these 3 seperate fields(day, month, year) into one date field in an access database, so that I can sort out entries by this date. Is there any way i could do this?
Thanks
ahksar

 

[GunJack]

Hey ahksar,

Is this what you need?

<cfquery ...

insert into table1
( myDate )
values (#createodbcdate(&quot;#form.month#/#form.day#/#form.year#&quot#)
</cfquery>

Hope this helps,
GJ

 

[ahksar]

It works!, Thanks for your help Gunjack .