Date control saving incorrect value in database

  • 23 November 2015
  • 0 replies
  • 7 views

Badge +9


 

Symptoms


Have various date controls on views. When using create/ save smo methods, the date on the controls are saved to the database as date - 1 day.
Replicated this using Smartbox smartobject with simple item view.
Server dates have been checked to see if dates are relevant on server side.

 

Diagnoses


The issue was caused by data type on the Calendar control is set different than the data type of the SQL back end.
 

Resolution

Update the Calendar control property values on a few views from date to date time fixed the issues.




 

0 replies

Be the first to reply!

Reply