Check if a date has passed

(0) Share

Report

Posted on by Bovi

Hi all,

I was wondering if I could get some help. For my app.

I need to check if the current date is after October 1st of each year. For example, now I want to check if the current date is past October 1st 2020 whereas in January I want to check if the date is past October 1st 2021, so the year has to be dynamic.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Bovi 40 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi All,

I think I have it, Ill post my solution here if anyone needs it
DateDiff(Today(),DateValue(Concatenate("1/10/",Text(Year(Now())))))
This returns a negative number if the date has passed, and a positive number if it hasn't.

If anyone had a more elegant solution, that would be great.

Was this reply helpful? Yes No
Verified answer

timl 37,271 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Bovi

Thanks for your question and for sharing your solution.

Here's how I would approach this:

(Today() > Date(Year(Now()),10,1))

This formula will return true if the data is passed, and false if it hasn't.

The key difference is that this formula calls the Date function to build target date of 1st October.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-date-time

The DateValue syntax that you specify has a dependency on a date format of dd/mm/yyyy.

This means that if a user in the US ran your app (or if a user setup their phone with US settings), the formula would compare today's date against 10th Jan. The Date function mitigates this potential problem.

Was this reply helpful? Yes No
Bovi 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @timl ,

That's a much more elegant solution, I'll implement that now.

It never occurred to me that users may be using it with their date an another format, that's a super useful tip to keep in mind moving forward!

Thanks again.

Was this reply helpful? Yes No
timl 37,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You're welcome @Bovi - glad to help!

Was this reply helpful? Yes No