Forum Discussion
DateAdd is adding one hour more on 31.3.2024
Dear Ladies and Gentlemen, in Power Apps I try to build a date with time. From Date Picker I get the date. From Dropdowns I add hours and minutes. It is working well for all test dates...
HI LadislavStupak,
If it is a Canvas app, you can set the Date time zone to UTC.
If it is a custom table, you can set it from the table in Columns by selecting the column and set the Time zone Adjustment to Time zone independent.
Hello stum,
thank you for your response.
When I change this setting to UTC, then I receive bigger differences, but then also by any day and time selection. Even day before is displayed as the result.
thank you for your response.
When I change this setting to UTC, then I receive bigger differences, but then also by any day and time selection. Even day before is displayed as the result.
HI LadislavStupak,
Sorry for the late reply. In that case I would keep the date time control's time zone as local and check the your time zone settings in Power Apps. Please see the screenshots below.
Hope this helps.
- Hello stum,
thank you for your response.
In this setting I have also my own time zone selected.
On the 31.3.2024 will the time change from winter to summer time.
And therefore I think it happens that I get one hour more in the result.
But it does not happen on the 30.3.2024 and also not on the 1.4.2024.
Therefore I would say it is a bug.- Hi.
You are welcome. Winter and summer time should not affect the calculation. I would try to create a test app and test the same case on that app and see if you get the same results.