I know when I was using MySQL, it used the dateformat of YYYY/MM/DD instead of MM/DD/YYYY. You may need to fix your dateFormat to display that correctly.
John Burns Certified Advanced ColdFusion MX Developer AI-ES Aeronautics, Web Developer -----Original Message----- From: Jason Smith [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 1:48 PM To: CF-Talk Subject: Date Issues Can anyone narrow down what the problem might be: The site I'm working on was built for access, I ported it to mysql after making all the needed changes for date stamps and anything else incompatible I have a new issue that seems to be random. When updating an Item via the administration application I have: *Item Date Received: <cfif isDate('#FORM.itemDateRecieved#')> <cfoutput><cfset DR = #DateFormat(FORM.itemDateRecieved, 'MM/DD/YYYY')#></cfoutput> <cfelse> <cfoutput><cfset DR = #FORM.itemDateRecieved#></cfoutput> </cfif> <!---ITEM DATE RECIEVED---> <tr> <td class="formTitle"><span class="votitle">*Item Date Received:</span></td> <td><cfif enabledYN eq "disabled"><span style="color:gray;"><cfoutput>#DR#</cfoutput></span><cfelse><cfinput type="text" name="itemDateRecieved" class="formBox" value="#DR#"></cfif></td> </tr> <tr> <td> </td> <td><span class="small">MM/DD/YYYY</span></td> </tr> Now when you update an item everything runs fine and seems to update but on certain items dates are still fouled up. One in particular I'm working on is always showing date 07/20/2012 and refuses to take anything else. Now could anyone tell me is this a cf problem or possibly a problem with the data field? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188425 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
