We have a dashboard, where the user can navigate dates, when the date is modified the data shown in the RG should match the selected date.
One of my customers is telling and showed me that on mobile, and pc, when they navigate trough the dates, the data displayed in the RG does not match the selected date.
i.e when the customer navigates to september 7th the RG displays the data of september 8th. When they navigate to september 19th , it displays the data of the september 20th and so on…
I’m uploading three pictures to give you in idea of the issue, the one that displays data for september 19 is wrong as there are not any record for september 19 in the database, that screenshot was made from one client this morning. The other two screenshots were made by me and they display correctly the data, nothing for september 19 , and several for sept 20th.
If so, double check your timezone override controls (Settings → General → Scroll all the way to the bottom). And then also check your logic and timezone override settings on the relevant page, date picker, and backend workflows (if applicable).
As the data type I`m collecting is Single Date , and it is saved in the format dd/mm/yyyy 12:00 am , I just realized that the repeating groups where displaying data on Current user timezone.
so basically every record was adapting this data , dd/mm/yyyy 12:00 am to the timezone of where the page was being opened. Meaning that if the reservation was made in France (GMT+2) but the repeating group was opened in i.e Portugal it would adapt to GMT+1 , meaning that the record that was registered in france as dd/mm/yyyy 12:00 am is going to be displayed in Portugal as -1dd/mm/yyyy 11:00 pm
The solution to this was to round down to day (everywhere in the repeating group where this data is used), time zone selection: Static and time zone: Paris
