How to check if a date is within a given range of dates

(0) Share

Report

Posted on by Community Power Pla...

Hello,

So I have a collection called Bank Holidays, that contains 10 different dates.

I then have 2 dates that are provided by the user, by using a date picker. The first date is always smaller than the second date e.g. 1/1/2022 - 5/1/2022 (day, month, year).

Now, I need to test if any of the 10 dates in the Bank Holiday collection are within the range of dates given by the user. If this is true, then i need to count how many of the dates are within the given range.

However, i am not sure how to do this in power apps, please can someone help?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report
Hello @Anonymous ,

You can compare dates with the ">" and the "<" sign to check if a date is superior or inferior when compared to another date. Just like numeric.

If(And(startDate < date, date < endDate), //date between startDate and endDate )

Was this reply helpful? Yes No