Date shift to previous day on save - UTC/Localize issue in DatePicker
0
Category: Studio Pro - Runtime Description: I am experiencing a critical issue with Date inputs where the selected date shifts to the previous day randomly (sometimes it works, sometimes the date is shifted). This happens during input/save, even without any Microflow manipulating the data. Current Behavior: • User selects "2026-04-10" in the Date Picker. • After saving in the database, the value becomes "2026-04-09". • This shift seems consistent with a -1h or -2h offset (French Winter/Summer time) affecting the midnight timestamp (00:00:00 → 23:00:00 or 22:00:00 previous day). Technical Context: • Localize attribute: Set to No (false). • Hypothesis: Even with localize = false, there seems to be a conversion conflict between the Session Timezone (Browser) and the UTC storage when the time part is defaulted to midnight. • Environment: Reproduced in Local (HSQLDB) and Cloud (PostgreSQL). Question: How can I ensure the DatePicker respects the UTC midnight value without applying a timezone offset that causes a date jump? Is there a known bug with the DatePicker widget when handling non-localized attributes in specific timezones?You will see attached 2 objects (Number : 2026-BPL-010 and 2026-BPL-011) that have been affected by the problem for their “StartDate”, which is a field that we put through a simple DatePicker. The original StartDate filled by the user was the day after, and it jumps to 22:00 the day before. But the 2 other objects you see after haven’t faced the same problem.
asked
Dan DRAY
1 answers
2
Hi Dan DRAY
The DatePicker always converts the picked date from the browser's local timezone to UTC before saving so midnight in France (UTC+2 in summer) becomes 22:00 the previous day in UTC, causing the -1 day shift. Setting localize = false only affects display, not this input conversion.
Fix: Go to App Settings → Runtime → Default time zone → set to Europe/Paris. This gives every user a proper timezone identifier so DST is handled correctly and the date no longer shifts.