Thanks Michael for the response.

1) I am using 2013.2 version of infragistics. Version 4.13.2.2157

2) This method converts my collection to json and then passes it on to the grid:

public ActionResult ConvertToJson<T>(ResponseWrapper<T> result)
        {
            ResponsePacket<T> dataViewModel = new ResponsePacket<T>();
            JsonResult jsonResult = new JsonResult();

            var pageSize = HttpUtility.ParseQueryString(Request.Url.Query).Get("pageSize");
            var pageIndex = HttpUtility.ParseQueryString(Request.Url.Query).Get("page");

            if (pageSize == null || pageIndex == null)
            {
                dataViewModel.Records = result.Content;
                dataViewModel.RecordCountKey = result.recordCountKey;
                jsonResult.Data = dataViewModel.Records;
                jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
            }
            else
            {
                dataViewModel.Records = result.Content.AsQueryable();
                dataViewModel.RecordCountKey = result.recordCountKey;
                jsonResult.Data = dataViewModel;
                jsonResult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
            }

            return jsonResult;

        }

The grid model is set up on my controller & the gridModel is generic in a way that it is for all the entities & the columns are set up dynamically like this :

 gridModel.Columns.Add(new GridColumn()
                    {

                       //record is my result set which contains the MetaData of the database table
                        HeaderText = record.DisplayName,   
                        Key = record.ColumnName,
                        DataType = record.DataType
                    });

Thanks I will implement it  in 3-4 days and let you know how it goes. Thanks for the help.

I will be awaiting your feedback.

Hello,

I'm just following up to see if you need any further assistance with this issue. If so please let me know.

Hello Denis,

I implemented your solution, Its not working for me. The following was the result I was getting BEFORE implementing your soultion:

The date on the server is : 2014-11-12 00:00:00.000

The date in the grid is : 11/11/2014 _7:00 PM

(12th date becomes 11th)

After I implemented your sample project I get a completely wrong date, I cant figure out the implementation details of your formatToServerTimeZone(date) function, is it specific to Pennsylvania? Are Daylight Savings setting different for every region ? Then this would be a problem. I dont want to hardcode the daylight saving settings. The following line does not make sense to me and if I have to modify it according to my region then this would become region specific, I dont think there is Daylight Saving in my country right now so what should be the setting?

Also one more thing.

I have a form (Master) also above the grid (Detail) . The same date 2014-11-12 00:00:00.000 from server is loaded in the form's datePicker and the date is displayed correctly like this : 11/12/2014

There is an event bound to this datePicker, on its selection changed event, the date of this (master's) datePicker is used to set the date in my Grid (detail). And the date 11/12/2014 becomes 11/11/2014 _7:00 PM . And if I commit the data the server's date also becomes 11/11/2014 00:00:00.000 BUT if I use the datePicker inside the grid (detail) and select 11/12/2014 then the correct date is displayed in the grid as well as on committing the row the server's date becomes 2014-11-12 14:00:00.000 and is displayed correctly next time in the grid.

From what I understand is that if I change the grid's date column through my master's datePicker, the date becomes one day behind, If I set the date through the grid's columns datePicker the date displays alright and the server also stores it correctly.

var date = $("#voucherPartyRefDate").igEditor("value");    // get date from master's datePicker

$("#voucherDetailGrid").igGridUpdating("updateRow", detailHeaderPk, {  //set date of detail(grid's) datePicker

vchr_dtl_ref_dt: date

}

-----------------------------------

If this is messing up the date than what should be done ? Is there another way to set the date of grid date column based on the date selected from master's igDatePicker?

Thanks.
            

Hello Zep,

Have you been able to resolve the issue? If not so I am still awaiting your sample project.

If you’re using also any of the editor controls (igDatePicker and igDateEditor) you should also set EnableUTCDates to true for them as well in order to have consistent dates from the same time zone.

I was facing the same problem. The issue was this: I had enabled UTCDates in the grid but I hadnt set UTCDates in my igEditor therfore the value I set from igEditor was being set as one day behind in the igGrid. Thanks for the question & your help. Appreciate it.