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.

• jqgrid
• date-format

Share Improve this question Follow asked Nov 21, 2024 at 1:53 sarsnakesarsnake 27.7k6262 gold badges185185 silver badges294294 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' ,...