jQuery Grid Plugin - jqGridForum

Topic RSS

Date Format not working

11/03/2010
18:30

cfaddict

Member

Members

Forum Posts: 5

Member Since:
11/03/2010

Offline

I have dates coming from my server that look like this > 20091214000000

If i use the following column model

{name:'ORD_DT',index:'ORD_DT',sorttype:'date',formatter:'date',formatoptions:{srcformat:'YmdHis',newformat:'m/d/Y'}},

Every single record is formatted to 01/01/1970

I realize this has something to do with UTC time/date but i have no idea what I am doing wrong.

Any help is grateful as this issue has ruined my morning 😉

12/03/2010
21:05

cfaddict

Member

Members

Forum Posts: 5

Member Since:
11/03/2010

Offline

Bueller?

15/03/2010
21:43

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Currently this will not work, since the format function expect to have separators. Sorry.

You can resolve the issue applying custom formatter:

http://www.trirand.com/jqgridw....._formatter

Best regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

18/03/2010
22:09

cfaddict

Member

Members

Forum Posts: 5

Member Since:
11/03/2010

Offline

Awesome! Thank you so much Tony!

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
54 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66