Hi Experts, I have a table called Program with Scheduled_date attribute. I scheduled a program on 30/03/2022 at 12:00 PM IST in Scheduled_date attribute. But in database the value for Scheduled date is stored as 29/03/2022 . I need to store what ever date which are entered in UI same should reflect on database also. How can I achieve this ? Thanks in Advance.
Have you already tried with the option localize to no?
The DateTime is being stored in UTC, which I believe is 5:30 hours behind IST, hence the time you are seeing in the database. It is converted back to local time when you use it in Mendix. There is a bit more about this behaviour in the part 2 of the DateTime FAQ. https://docs.mendix.com/refguide/datetime-handling-faq/