I’ve built an app with a date picker as part of a form, basically for users to indicate their date of birth.
I’ve gotten some feedback from various users of the app that the date picker does not seem to be working properly for them. The most common issue is that they’ll select a date on the pop-up calendar, but after pressing “OK”, what’s reflected on the field of the form is a day off what they’ve selected on the calendar.
For example, someone encountering this issue may pick 10 June 2021 on the pop-up calendar, but after selecting the date it will reflect as 9 June 2021 on the field of the form.
Strangely after submitting the form, the correct date is then reflected for some, but not for others. And this problem only happens for certain users, not all. The frustrating thing is that it works perfectly fine for me so I can’t replicate the issue on my end. So I am relying on a lot of trial and error and feedback to fix the issue.
I’m also wondering if this is a timezone issue. I’m from Singapore (GMT +8) and I’ve made sure the Google Spreadsheet is in the correct timezone, but I’m just wondering if it is because the calendar is based off a different timezone and is trying to adjust and compensate for the difference, therefore the issue. But it’s just a suspicion.
Any suggestions on how to fix the issue? Would really appreciate any help. Thanks in advance!