Good afternoon,
in a form with two Calendar controls, after the submit button is click the dates are stored in the database in the correct format.
However when we read back from the database the date format is wrong.
Example:
- If in the form is saved as 2014-12-08, on the database appears 2014-12-08, but after read on the form looks like 2014-08-12
- If in the form is saved as 2014-12-25, on the database appears 2014-12-25, but after read on the form looks like (empty) (it tries 2014-25-12 which is impossible)
In attachment "K2DateControlReadWrongFormat.png" i post how the form calendar shows the forms after reading the fields, the database values and the calendar custom format.
Waiting for advice.