View Full Version : formatting datefield output on submit

18 Aug 2009, 2:06 PM
I'm using a Date field in a new-record form for a mySQL DB. See the "expectedDate" form item in the code below.

newRecordForm = new Ext.FormPanel({
bodyStyle: 'padding:10px',
items: [
{name: 'eventTitle', xtype:'textfield', fieldLabel: 'Event title', width: 300, maxLength: 255, allowBlank: false, blankText: 'Event title is required'},
{name: 'eventType', xtype:'combo', fieldLabel: 'Type', store: TypeStore, mode: 'local', triggerAction: 'all', displayField: 'itemName', valueField: 'itemValue', value: 'Film', editable: false},
{name: 'expectedDate', xtype: 'datefield', fieldLabel: 'Date expected', editable: false},
{name: 'notes', xtype: 'textfield', fieldLabel: 'Notes', width: 300, maxLength: 255}
buttons: [
{text: 'Save and Close', handler: createNewRecord},
{text: 'Cancel', handler: function(){newRecordWindow.hide();}}
function createNewRecord() {
if( newRecordForm.form.isValid() ) {
url: 'actions.php', waitMsg: 'Please wait...',
params: {task: 'ADD'},
success: addSuccessResponse, failure: failureResponse
} else {
Ext.MessageBox.alert( 'Warning', 'Your form is not valid!' );
newRecordWindow = new Ext.Window({
id: 'newRecordWindow', title: 'Add an item',
layout: 'form', width: 650, closable: false,
items: newRecordForm

Question: is it possible to convert the datefield value to mySQL format automatically upon form submission, while still having it appear in the date selector as a "human-readable" date?

I tried adding format: 'Y-m-d' to the datefield definition, but that forces the input field to display the selected date in MySQL format. I can also add editable: false so the user can't over-type that value. This isn't really an ideal solution though, because MySQL-format dates are less readable to my users. Ideally, I'd like the selected date to appear in the field as a human-readable date, but magically convert to a mySQL-style date when the submit button is clicked. And, if it could be done in the form definition, I could reuse my createNewRecord function elsewhere.

There's no "outputFormat" config item for datefield, but that's what I'm looking for.

19 Aug 2009, 6:13 AM
Never mind, just found a relevant thread & Saki's extension at http://extjs.com/forum/showthread.php?t=25900