I am saving a DateTime column in an OutSystems aggregate. Since my project is used worldwide, users from different countries are saving values. When retrieving, the date remains the same but the time varies, so some columns are not matching correctly
Hello,
When you get a datetime from the user (e.g. DateTime Picker), you must convert it to UTC before saving.
YourEntity.YourDateTimeColumn = GetUTCFromLocalDateTime(LocalDateTimeInput);
Thank you.
Hi,
In Reactive Web application, DateTime values are automatically converted from the user’s local time zone to UTC when captured from the UI, and then back from UTC to the local time zone when displayed. This confirms the mechanism is working as intended.
Can you confirm is this same behaviour you are getting there.
Please refer to the article below.
https://success.outsystems.com/documentation/11/reference/outsystems_language/data/data_types/available_data_types/