I've had this problem many times. A solution, that probably isn't the most elegant, is to change that field in Access to a Text field and insert you date field as a string. Change your code to the following: <cfinput type="text" name="Date" size="10" maxlength="10" required="yes" validate="Date" message="Date is required!" value="#DateFormat(Now(), 'mm/dd/yyyy')#"> This way, you don't have to worry about Access Date Format compatibility, and that line of code should ensure all values entered into that field are Dates in the format you want. I have done this many times and it has worked well. There is also a DATE field in Access, but I forget exactly what the format is for that field. Using my option should work fine as a workaround. Gregory Weiss -----Original Message----- From: Shally Kon [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 29, 2000 12:54 AM To: [EMAIL PROTECTED] Subject: Please help me! I am trying to insert 3 fields plus current date into my table .What I want is that when ever the form is loaded the current date should popup automatically in the format "mm/dd/yyyy" and when I press submit button then all the fields plus the current date should be inserted in the table.I am using Create date function.but the output I am getting is "{d '2000-04-28'}" as the output.I am using access database and have specified the datatype of date field as "date/time". <cfinput type="text" name="Date" size="10" maxlength="10" required="yes" validate="Date" message="Date is required!" value="#CreateODBCDate(Now())#"> ----------------------------------------------- FREE! The World's Best Email Address @email.com Reserve your name now at http://www.email.com ---------------------------------------------------------------------------- -- 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. ------------------------------------------------------------------------------ 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.
