I have an application where I'm gathering customer data via Kendo UI spreadsheet with DataSource. One of the fields is a DateOfBirth which I need to capture in en_GB format: dd/mm/yyyy. Please see this JsFiddle as an example: https://jsfiddle.net/s4c87msq/3/
Following are the issues:
1. If you enter text "01/03/1999" into any column - text or number or date, it gets parsed as en_US date (so the content of the cell changes to "03/01/1999"). How do I stop a texrt field being parsed as a date?
2. I'm having to set the DataSource schema DateOfBirth field type to "string" because if it is set to "Date" I get an error when kendo tried to parse it on change: TypeError: e.indexOf is not a function
Can you please refer to the JsFiddle and let me know how do I get the correct date from Spreadsheet in the dataSource?