Handsontable example - JSFiddle - Code Playground , Here i tried to change the dateformat in handsontable. but it not working. my date format getting from db is look like “2025-12-23 00:00:00“. Here i need to convert this format into “23-12-2025” (DD-MM-YYYY) in handsontable. but it not working. Check the Jsfiddle i add a link.
Hi @saran456
Thank you for contacting us. Here’s an example showing the DD/MM/YYYY format: Handsontable example - JSFiddle - Code Playground The example you sent uses very old version of Handosntable, the current one is 16.2 and we highly recommend using the latest version. Please, also consider the fact that Handontable doesn’t automatically convert the date if the data provided is in different format.
In the new version DD-MM-YYYY format not working. When I add this format in date format and i select it it show wrong value. 2025-12-26 → 20-12-2026
Kindly check it. And also Provide me a sample example of this format DD-MM-YYYY
Hi @saran456 my colleague @adrian.szymanski on vacation so I’m here to reply.
Here’s the updated demo Handsontable example - JSFiddle - Code Playground to use DD-MM-YYYY format.
Now, when I use the DD-MM-YYYY dates across my data and pick a value from a calendar it is converted correctly (the 16th was chosen)
Then, when a value is manually edited within a cell editor that fits the format, it is understood and visualized as a correct date.
Now, when I want to pass a date that is different than the format as YYYY-MM-DD (here 2025-10-01), Handsontable tries to convert the data, but it can’t, so the value becomes 20-10-2001.
Based on the documentation enabling correctFormat option should do the job
Ref: Options API reference - JavaScript Data Grid | Handsontable
so I’ll report this issue internally to the team. I’ve also noticed a few related formatting inconsistencies (for example, the date format when YY is set at the end or in the middle), so this may be connected.
I’ll keep you updated as soon as we have more information. Thanks so much for flagging this - we really appreciate it!
1 Like