Change default date format in datagrid

[Jakob]

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

[stworthy]

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>

[Jakob]

<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?

[stworthy]

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>

[Jakob]

Getting error

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

Code:

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

[stworthy]

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