Hello Johnny,

Did you change the format in the column definition to the necessary one? For example:

columns: [
     { headerText: "Product ID", key: "ProductID", dataType: "number" },
     { headerText: "Product Name", key: "Name", dataType: "string" },
     { headerText: "Product Number", key: "ProductNumber", dataType: "string" },
     { headerText: "Date", key: "Date", dataType: "date", format: "dd MMM yyyy" }
]

If this is done and it still does not work please provide me with a working sample, so I can investigate the issue.

Regards,
Ivaylo Hubenov
Entry-level developer

Still no luck. Deleting dateDisplayFormat in editor, the result is same. I choose 3 jan 2017 and it become 1 march 2017. I did it in child grid of hierarchical grid.

Hello Johnny,

Please try setting the format of the date column to "dd MMM yyyy".

I am attaching a sample, where this is done. Please test it and let me know how it went.

Regards,
Ivaylo Hubenov
Entry-level developer

Hmm thankyou, but I already solved it with adding "enableUTCdates false".

Another problem is when I editing date with datepicker in child of HierarchicalGrid, I set DateInputFormat as "dd/MM/YYYY" and DateDisplayFormat as "dd MMM yyyy" it often lead to false date. For example, new column is empty and I pick 3 Jan 2017. Then it fill as 1 March 2017.

But, if I set DateInputFormat as "date" and DateDisplayFormat as "dd MMM yyyy", it shows the correct date.

Any solutions?

Regards.