I have an igGrid where one column is a date. For some reason, the date displayed is always one day behind the date's value.
The column definition is:
{ headerText: "Settlement Date", key: "settlement_date", dataType: "date", format: "MM/dd/yyyy" }
I have the page displaying the JSON source data, which is:
[{"settlement_date"=>"2013-04-17", ...
But yet the igGrid displays "04/16/2013" instead of 4/17.
If I change the dataType to "string", then it displays "2013-04-17". So it appears to be Ignite's conversion to "date" that is screwing it up. (This would be ok, except that I can't format it now.)
Can someone please clue me in on what's going on and how I can fix it?
Hello,
What igGrid tries to do when the date is represented as a string in the data source is to initialize a new Date object using the string and then get its components with the Date API. Date assumes the string is representing an UTC date and therefore you should set enableUTCDates Grid option to true if you need the data source string and the string used by the formatter to be the same.
I hope this helps! Thank you for using Infragistics forums!
Best regards,
Stamen Stoychev
I don't entirely understand how UTC would cause a timeless date string to become yesterday. It's certainly not what one would reasonably expect.
I can't say this is a good answer, but it is an accurate one, I suppose.