Hi,
I have an interactive report with an auto generated form to edit the entries, but there are problems with dates.
The dates are saved in the database as MM/DD/YYYY format, but I want them as DD/MM/YYYY in my application. When I apply the format mask to the report, everything is fine.
I also applied the same format mask to some date picker fields in the form.
But when I open the form, the format masks are not applied to some dates.
Example 1:
Date: 01 September 2022
DB: 09/01/2022
Report: 01/09/2022
Date Picker: 09/01/2022
Since the format mask of the Date Picker is DD/MM/YYYY, it then saves 09 January 2022 to the database.
Example 2:
Date: 13 September 2022
DB: 09/13/2022
Report: 13/09/2022
Date Picker: 13/09/2022
Since there is no 13th month, everything works fine and it is saved as the right date and format.
How can I solve this issue?
Thanks in advance