> Your problem is that CreateODBCDate creates, well, an ODBC date object
> which is in the format above. To solve this use CreateDate(Now())
> (optionally using DateFormat(...) to format to your desired
> display) to fill the
> date field, and convert the results to an ODBC date before inserting into
> the table by using CreateODBCDate() with the contents of your form field
> (depending on the format you might have to use CreateDate on the form
> field first and use the date/time object for the CreateODBCDate() call).
Why use CreateDate at all? DateFormat(Now(),"mm/dd/yyyy") will do the job.
The databases prefer ODBCDateFormat for their input, it guarantees that it's
in the correct format, but you can do the fiddling with that before you put
the data into the table
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
