Ok, this will be short but very condensed so please, whoever jumps in to help, ask freely for more info if necessary.
1) date and time picker outputs a date and time
2) a "get local timezone" action returns the timezone of the user from the device in the format: Europe/Athens for example
3) a "convert to UTC" action takes the "Date Picked" and the "Timezone" outputs and turns it into UTC
4) a "convert to Local time" action takes the UTC and the Timezone and converts it into the local time.
5) I bind the two Conversion actions outputs to two different text fields - without any changes in format - Raw
ISSUE: when running Test mode - with the debugging panel on the left - I see both outputs stored in their variables as Local time.
WHILE: on the app screen of the test mode where I have bound the texts which "print" exactly the same outputs from the same actions I see UTC and Local correctly as expected.
Please someone help!
Thank you!
Very weird things happening with time, timezones & timestamptz
Troubleshooting
Looked everywhere and realised the time + timezones issue is deep and difficult.
Both Claude & chatgpt could not be of serious assistance.tr
Yes
3
2 replies