I am trying to use this to fix the formatting from Interakts MXWidget Calender tool, but it doesn't seem to be working, how do a force a rewrite of the Update/Insert record command so the new code from this extension is working? Could MXWidget conflict with this extension somehow?
After installing this extension, I noticed the date would insert correctly only some ways you enter it, if you enter the date as 09-02-2004 it gets messed up & inserted as 2015-03-27. Also this totally screws up any fields you set as Time in mySQL. Now anything I type for time ex. 9:00 or 16:00 always shows up as 00:20:04. I hope this thing will un-install...
...I've installed it... made a form with a date field, sending date value to the db. The db table has, of course, a DATE place... but the only things I get is 0000-00-00
Why...? Is there a way to use it? I would like to enter the date in EU format (dd-mm-yy) and put it in...
I am using this extension in the uk and have amended the "Y-m-d" to "Y-d-m" as previously stated. Even with this a date such as 25/05/04 and 30/05/04 is getting entered into the database date fields as 1/5/2006 and 6/5/2006 respectively. Please could you point out where i am going wrong??
I am using this extension in the UK. The standard format in which we write dates is dd/mm/yy - in the states it appers to be mm/dd/yy. I have found it necessary to modify the code created by this extension when formatting the date value by replacing the line:
After installing it myself my dreamweaver mx 2004 has a total fit with record insertion. I lose the ability to see the record insertion behavior in the behaviors menu. Thus I loose the ability to edit record insertion params in general. All because this module puts an extra if in the dreameaver get mysql strings function for checking dates. This then permanently confuses dreamweaver that the record insertion is not there. Mind you this module doesn't except European Dates either.
This extension alters the record insert and update behaviors so that your users can enter a date in almost any format and have it automatically changed to YYYY-MM-DD before inserting/updating into the database.