Date Picker always 1 day off

Building my first app and I’m having issues with the date-picker in app forms. Calendar renders nicely for example:

However, when I click on a day, for example here I clicked on Tuesday 8th

The correspoding field is always populated one day earlier - for example in this case April 7th.

Looking for ideas as this really makes it unusaeble. Anyone encountered this behavior?

Hi @valsoar1, I am trying to reproduce this issue but I’m not able to on my side.

What browser are you using? Are you able to send me a link to the published app so I can check this myself?

I’m using Edge on Windows 11, but I get the same result when I bring up the app on an iPad so I don’t beleieve its a browser specific issue.

Hey @valsoar1, could you also let us know your time zone?

I am in US/Eastern. That said I I will add that I am 5 hours behind GMT/Zulu, the date does not jump forward to GMT, it goes back one day. It also does so whether within 5 hours of midnight or greater than 5 hours from midnight.

Thank you both for looking at this.

Thank you @valsoar1. We have confirmed this is a bug. You can track the fix here: Date Localization Bug in Datepicker (#3566) · Issues · Baserow / baserow · GitLab :blush:

Thank you for the update. I’ll watch for the fix.