Filter by date range in a gallery

(0) Share

Report

Posted on by developingteal

392

Here is my filter:

And(
 Or(
 IsBlank(Value(startDateExc.SelectedDate)),
 HoursDate >= DateTimeValue(startDateExc.SelectedDate)
 ),
 Or(
 IsBlank(Value(endDateExc.SelectedDate)),
 HoursDate <= DateTimeValue(endDateExc.SelectedDate)
 )
 )

whenever I change the start or end date to things where there should be records displaying in the gallery, it just doesn't. I am incredibly confused, and was wondering if there was some insight. I am comparing two dateTime values, and both are formatted the same. What am I missing?

Thanks for the help.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

developingteal 392 on at

Like (0)

Report
Copy link

Link copied!

It might be important to note I am using sql server and the hoursDate column is a DateTime value

Was this reply helpful? Yes No