Hi, I'm recieving UTC dates from the server formatted as JSON, what I want to find out is how the grid handles UTC date. displaying the dates as local time received from the server and to the server when filering on date columns?
Please can u advice on how to resolve this issue.
Thanks in advanced.
Regards Christoff
Hi Christoff,
i am not sure i understand correctly - are you using the MVC wrapper? In that case the Microsoft JSON serializer sends dates in the format \/Date(1294268400000)\/. Then this is handled by the client-side code, i.e. this special format is recognized and parsed.
if you have some custom backend, which sends dates as strings, or as ticks, specifying the column "dateType" to be equal to "date" will automatically convert those to Date objects. This is done without adding any local offset, i.e. everything is assumed to be UTC and is not converted to local dates and times.
Let me know if this helps. Thanks,
Angel
Hey Angel
If I can explain this a little bit more clearly.
I receive the date from the server in the format: /Date(1334837100843)/ (Witch is an UTC date)
On the column definition I have:
{
headerText: "Received",
key: "Received",
dataType: "date",
format: "dateTime",
width: 45
},
After the date is rendered the date is displayed as: 4/19/2012 12:05 PM
But the correct local value should be: 4/19/2012 14:05 PM
If I project the value like so: new Date(1334837100843), I do get the correct 4/19/2012 14:05 PM value.
Another thing I am having trouble with is that your jquery editors do have support for culture information, but could not find the same functionality on the grid control.