EasyUI Forum

General Category => EasyUI for jQuery => Topic started by: Jakob on April 04, 2013, 11:22:01 AM

Title: Change default date format in datagrid
Post by: Jakob on April 04, 2013, 11:22:01 AM

Hello

I have been looking to change the default date format of dates which appears in datagrid as

Code:

Apr 2, 2013

.

I would like to change the format to e.g.

Code:

mm/dd/yyyy

rather than changing in database.

Thanks

Title: Re: Change default date format in datagrid
Post by: stworthy on April 04, 2013, 10:26:23 PM

Please use column 'formatter' function to format field value.

Code:

<th data-options="field:'fn',formatter:formatDate" width="80">Date</th>

<script>
function formatDate(value,row){
  var d = new Date(value);
  return $.fn.datebox.defaults.formatter(d);
}
</script>

Title: Re: Change default date format in datagrid
Post by: Jakob on April 05, 2013, 10:00:32 AM

Quote

<th data-options="field:'fn',formatter:formatDate" width="80">Date</th>

<script>
function formatDate(value,row){
var d = new Date(value);
return $.fn.datebox.defaults.formatter(d);
}
</script>

I have date field defined as

Code:

{field:'productDate',title:'Date', width:40, sortable:false, editor:'text'},

so how can use formatter?

Title: Re: Change default date format in datagrid
Post by: stworthy on April 05, 2013, 10:03:39 AM

Try this code.

Code:

{field:'productDate',title:'Date', width:40, sortable:false, editor:'text', formatter:formatProductDate},

<script>
function formatProductDate(value,row){
  var d = new Date(value);
  return $.fn.datebox.defaults.formatter(d);
}
</script>

Title: Re: Change default date format in datagrid
Post by: Jakob on April 05, 2013, 10:47:39 AM

Getting error

SyntaxError: missing : after property id
[Break On This Error]

Code:

...Date', width:40, sortable:false, editor:'text', formatter="formatProductDate"}

Title: Re: Change default date format in datagrid
Post by: stworthy on April 05, 2013, 04:48:50 PM

Please refer to this example http://jsfiddle.net/2mbau/. It works fine.