datefield problem with access 2003 and coldfusion

[rbmako69]

I'm using a flash form to input some data into my access database. one of the fields is a type=datefield. When i output the actual data just before the sql insert that date is in the correct format; mm/dd/yyyy. So thats fine, but when i look at the actual data in access instead of being a date such as 11/1/2006 its something like 12:19:43 AM.

I have been beating my head against the wall trying to figure out what is going on. Does anyone have any ideas what is going wrong?

[PEB]

It seems that your date isn't enterd in the database..

Behind those values is maybe the 0 value! But in fact not... The 0 also corresponds to a date and time..

Is your field has a properties to be of type Date and Time or only it's assigned for Time?

[rbmako69]

Is your field has a properties to be of type Date and Time or only it's assigned for Time?

I'm unclear what you are asking. In the app. i have a <cfinput type="datefield " ...>

The field in the database is is type date/time.

[PEB]

Yeah,

Have you tried to introduce manually a date?
How do you connect with ColdFusion?

[rbmako69]

I have tried to enter the date manually, but when i do something else breaks.

As for connecting with coldfusion, i'm not sure. i have the cfserver running with apache as the webserver, and i'm developing in dreamweaver. i don't know if that what you are asking though

[MMcCarthy]

I'm unclear what you are asking. In the app. i have a <cfinput type="datefield " ...>

The field in the database is is type date/time.

What is the format of the date/time field?

[rbmako69]

What is the format of the date/time field?

Are you refering to the access field or the field in coldfusion

[MMcCarthy]

Are you refering to the access field or the field in coldfusion

The Access Field