cfupdate and date fields

[sevex]

I have an update record style form that contains a date field made up of three drop-down lists, month, day and year (naturally)

I'm using cfupdate to update the record, and listing all of the fields that are to be updated. My date field is called "Opening_Date" and it's in there. Before the cfupdate tag I have:

<cfset Opening_Date = createODBCdate(CreateDate(#year#, #month#, #day#))>

to try and create a date from the fields and have it use it. It updates every other field, but not my date field. Thanks in advance for any ideas or suggestions.

 

[GradStudent]

Hi,


try :

<cfset Opening_Date = dateFormate(CreateDate(#year#, #month#, #day#), &quot;mm dd yyyy&quot>