web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Identify overlapping o...

Power Apps

Answered

Identify overlapping of date range

(0) Share

Report

Report

Posted on by Raj301189

Hi Team,

We have a Leave management system where a user submits various leave plans for a month. When a user is selecting a date range for a leave plan , the date range should not be overlapping with the already selected date range.

Please let me know how to proceed on this.

Thanks in advance

Thanks,

Raj

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Raj301189

In essense, this structure will return true if the date ranges overlap.

With( { startTime1:DateTimeValue("2022-01-05 10:00"), endTime1:DateTimeValue("2022-01-05 11:30"), startTime2:DateTimeValue("2022-01-05 09:30"), endTime2:DateTimeValue("2022-01-05 10:30") }, startTime1 < endTime2 && startTime2 < endTime1 )

My post here describes this in more detail.

http://powerappsguide.com/blog/post/detect-overlapping-times
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Raj301189 :

I assume selected date is a list:

ClearCollect( SelectedDate, {StartDate:DateTimeValue("2022-04-10 12AM"),EndDate:DateTimeValue("2022-04-11 12AM")}, {StartDate:DateTimeValue("2022-04-11 12AM"),EndDate:DateTimeValue("2022-04-12 12AM")}, {StartDate:DateTimeValue("2022-04-12 12AM"),EndDate:DateTimeValue("2022-04-13 12AM")} )

and there are two date picker controls (DatePickerStart/DatePickerEnd)

You could try this formula to get if the select dates are overlapping with the already selected date range:

IsBlank(LookUp( SelectedDate, (DatePickerStart.SelectedDate<EndDate && DatePickerStart.SelectedDate>=StartDate) || (DatePickerEnd.SelectedDate<=EndDate && DatePickerEnd.SelectedDate>StartDate) || (DatePickerEnd.SelectedDate>=EndDate && DatePickerStart.SelectedDate<=StartDate) ))

This formula will return true if the dates are not overlapping with the already selected date range.

Best Regards,

Bof

Join the conversation