Unanswered

Filter gallery by comparing two dates

(0) Share

Report

Posted on by Sesese

Hey guys,

I want to filter a gallery by comparing the date on a column and today.

In the SP list the column is a string formatted as "dd/mm/yyyy" but when i go to filter the gallery as "Filter(Gallery1;Bookingdate>=Text(Today();"dd/mm/yyyy")) it gives me error.

Any tips?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report
Check the data type in the Bookingdate column, whether it is plain text or date. If it's date, you don't need to use the Text() function. If it's text, you can do it like this:

Filter( Gallery1, DateValue(Bookingdate) >= Today() )
More information about the DateValue function here.

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
You need to do this:

Filter( Gallery1, DateValue(Bookingdate) >= Today() )

You need to compare date with date, rather than date with text.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No