jqgrid date formatter from and to formats

I have the date coming in as 30-Oct-24 and I need it displayed as 30-Oct-2024 and also need to be able to sort by date

I have this code but it's not working and showing gibberish strings instead

 formatter: 'date', formatoptions: { srcformat: 'd-MMM-yy', newformat: 'dd-MMM-yyyy' }, sorttype: 'date'

Is there a list of date formats for JqGrid that I can find somewhere? This should work but does not.

I have the date coming in as 30-Oct-24 and I need it displayed as 30-Oct-2024 and also need to be able to sort by date

I have this code but it's not working and showing gibberish strings instead

 formatter: 'date', formatoptions: { srcformat: 'd-MMM-yy', newformat: 'dd-MMM-yyyy' }, sorttype: 'date'

Is there a list of date formats for JqGrid that I can find somewhere? This should work but does not.

Share Improve this question asked Nov 21, 2024 at 1:53 sarsnake 27.7k62 gold badges185 silver badges294 bronze badges

Add a comment |

1 Answer 1

Sorted by: Reset to default 0

jqGrid follow the php date formatting. This is described into the documentation

In your case you can try with:

... srcformat : 'd-M-y', newformat : 'd-M-Y' ,...