Index
» Projects
» phpMyEdit
» Forum
» strftimemask in edit mode |
|
joe438
Joined: 23 Jun 2008
Posts: 2
Posted: 2008-06-26 19:37
Back to top
Reply with quote
|
I have 2 date fields that I have applied a strftime mask to so they display %m/%d/%Y. They display correctly in list mode and view mode.
However, edit mode defaults to displaying them in %Y-%m-%d as read from the database. How can I get the same mask to appear in edit mode?
It's very confusing to the users to see the dates in this format only when editing.
I've already written update and insert triggers to convert any valid dates entered to the proper format for mysql.
|
ajh
Joined: 17 Dec 2003
Posts: 236
Posted: 2008-06-27 15:24
Back to top
Reply with quote
|
The only way I know of doing it is to use a 'sqlw' to convert the text input into the correct format for MySQL...so you would write an expression to convert:
mm/dd/yy to yy/mm/dd
The alternative is to use an extension like mce_cal (in the CVS) to use a Javascript calendar popup for the field.
|
Post new topic
Reply to topic
|
|
|
|