web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Crossover to British S...
Power Apps
Answered

Crossover to British Summer time (and winter time) breaking power app

(0) ShareShare
ReportReport
Posted on by 381
Hi, 
I've built a desk booking app that checks if a desk is booked either for a whole day, morning or afternoon.
The validation code will hide desks where there is a clash, so the desk with a reservation can't be selected.
For example, if the desk is booked for the morning it won't allow the same desk to be booked all day but will allow the afternoon to be booked.
 
Everything works fine for bookings up to and including Saturday 28th March.
 
However, as we move to British Summer time (Sunday 29th March 2026) the code fails and totally ignores any existing bookings made from the 29th onwards.
 
In the previous example, if the desk was booked on or after the 29th for the morning other users would be also able to book it for the morning or whole day.
It's as if the code totally ignores any bookings made after the 29th.
 
I could understand it if the booking was for 2 or 3 am, when the clocks change on the 29th. But to ignore a whole day and subsequent days makes no sense.
 
Any ideas?
 
 
I have the same question (0)
  • BCBuizer Profile Picture
    22,620 Super User 2026 Season 1 on at
     
    Can you please share the formula that is failing for review? Without that, giving any kind of tips/feedback is nearly impossible.
     
     
    If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.
  • Verified answer
    11manish Profile Picture
    395 on at
    This isn’t a bug in your logic—it’s a timezone boundary issue exposed by DST.
    After 29th March:
    • Your app isn’t “ignoring bookings”
    • It’s failing to match them due to a 1-hour shift in stored time
    Use date range instead of equality
    With(
        {
            startOfDay: DateValue(SelectedDate),
            endOfDay: DateAdd(DateValue(SelectedDate), 1, Days)
        },
        Filter(
            Bookings,
            BookingDate >= startOfDay &&
            BookingDate < endOfDay
        )
    )
     
    Another Solution :
     
    Normalize to UTC explicitly
    With(
        {
            selectedUTC: DateAdd(SelectedDate, -TimeZoneOffset(SelectedDate), Minutes)
        },
        Filter(
            Bookings,
            BookingDate = selectedUTC
        )
    )
     
    Best solution to compare date value only
  • Gary_Eden Profile Picture
    381 on at
    Thanks for your suggestion, that makes sense. I'll try it out today and let you know how I get on.
     
    My apologies for not replying to your post earlier. I use Firefox as my default browser and the PP community site doesn't work properly in it... I could post but couldn't get to reply (constant page load spinner blocking access). 
  • Gary_Eden Profile Picture
    381 on at
    Thanks for your help, we had similar code but forgot the minus (-) on the TimeZoneOffset.
    Obvious when you know what to look for :)
    Cheers
    Gary

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 509 Most Valuable Professional

#2
Haque Profile Picture

Haque 302

#3
11manish Profile Picture

11manish 265

Last 30 days Overall leaderboard