U4-7624 - Datepicker Sql server error

Created by Leo 30 Dec 2015, 14:23:26 Updated by Shannon Deminick 05 Jan 2016, 14:47:55

After update to 7.3.4. there seems to be a problem with the datepicker in combination with custom date format (DD-MM-YYYY).

When you have a documenttype with a datepicker and the datepicker has a custom format the post to the server it goes wrong when you try to save and publish an existing node if you not changed the date.

i.e: the date 23-5-2015 is send in json as: {"id":134902,"alias":"datum","value":"0023-05-20"} This results in: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

When you actualy choose a date with the calendar (remove old date and choose new date) the json looks like: {"id":115997,"alias":"datum","value":"2015-05-23"} And then it saves without the sql error.

So it seems the date is not properly formated during loading of the page in angular.

Steps to reproduce: Set Custom format of datepicker datatype to DD-MM-YYYY. Create documenttype with a date property of type datepicker (mandatory) Add document to content with the new documenttype and save with a date filled in.

Change to another node and select the same document again. Click Publish and the SQL error occurs.


Claus Jensen 04 Jan 2016, 10:57:04

commit: https://github.com/umbraco/Umbraco-CMS/commit/3a4f0f4c114f80d4d1c7463daa7510dedcc78792

Priority: Major

Type: Bug

State: Fixed


Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 7.3.4

Due in version: 7.3.5

Sprint: Sprint 6

Story Points: