I am getting following value in date column in Handsontable (in database column is datetime and using asp.net web api)
2014-11-13T20:29:00+05:30
I am using following configuration
type: ‘date’,
dateFormat: ‘MM/DD/YYYY’,
correctFormat: true,
defaultDate: ‘01/01/1900’,
// datePicker additional options (see https://github.com/dbushell/Pikaday#configuration)
datePickerConfig: {
// First day of the week (0: Sunday, 1: Monday, etc)
firstDay: 0,
showWeekNumber: true,
numberOfMonths: 3,
disableDayFn: function (date) {
// Disable Sunday and Saturday
return date.getDay() === 0 || date.getDay() === 6;
}