Hi,
I recently updated to 7.3.4. and now 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.
Datepicker Sql server error 7.3.4
Hi, I recently updated to 7.3.4. and now 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.
Regards Leo
Hi Leo,
You can report an issue with Umbraco on the issue tracker: http://issues.umbraco.org/dashboard
Hi Tom,
I filed it. http://issues.umbraco.org/issue/U4-7624 I hope the description is clear enough.
Regards Leo
is working on a reply...