>I've been having problems inserting the CurrentDate in Access as well. I've
tried setting the data type up as a text and as a date/time, but neither
work.
>
>What is the best way to do it?
The best way is NOT to insert it. Instead, set the default value of the
field (in Access) to Now() or Date(), depending on if you want an exact
timestamp or just the date. This way you leave the task of retrieving and
formatting the current date to the DB, thereby taking that task away from
CF.
Regards,
Seth Petry-Johnson
Argo Enterprise and Associates
------------------------------------------------------------------------------
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.
