jQuery Grid Plugin - jqGrid - Topic: date formatter question

cwillard on date formatter question

Wed, 03 Nov 2010 17:23:01 +0200

OlegK said:

It seem to me that your source date format is too bad to be interpreted by the standard date formatter. With the writing your custom formatter you will be able to read the date. Why you not use ISO8601Long format "Y-m-d H:i:s"?

Well, I just thought a timestamp like 201011031122 would be simple to get from the server. I can use another format. I was just surprised that it was not able to be converted. I would think if this is using a regex, it should be able to handle any format, even ones without spaces.

Thx for the feedback.

OlegK on date formatter question

Wed, 03 Nov 2010 16:14:31 +0200

It seem to me that your source date format is too bad to be interpreted by the standard date formatter. With the writing your custom formatter you will be able to read the date. Why you not use ISO8601Long format "Y-m-d H:i:s"?

cwillard on date formatter question

Wed, 03 Nov 2010 15:33:49 +0200

anyone?

cwillard on date formatter question

Tue, 02 Nov 2010 21:23:42 +0200

I am attempting to convert dates from one format in JSON to a different format for display. I am using the newest version of jqGrid with jquery1.4.3.

Here is the relevant code:

colModel: [
...

{ name: 'lastAllocation', index: 'lastAllocation', formatter: 'date', formatoptions: { srcformat: 'YmdHi', newformat: 'd/m/Y g:ia' } },
...

]

The date I'm trying to convert is "201008120610", but what is being displayed is 01/01/1970 12:00am. It seems like perhaps the lack of spaces is what is causing the problem.

Does anyone know anything about this and what I might be doing wrong?