Forum Discussion

stum's avatar
stum
Copper Contributor
Mar 19, 2024

Re: DateAdd is adding one hour more on 31.3.2024

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.

 

4 Replies

  • LadislavStupak's avatar
    LadislavStupak
    Brass Contributor
    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.
    • stum's avatar
      stum
      Copper Contributor

      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.

      1.  

      Hope this helps. 

      • LadislavStupak's avatar
        LadislavStupak
        Brass Contributor
        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.

Resources