Date Range From DataVerse Table

[Kaiserfaust]

Good morning!

I'm attempting to build a reservation app and I have most of what I need built. I'm struggling on a way to basically filter or perhaps use an IF statement for my date ranges. The two fields I'm attempting to associate the reservation to are the resFrom to the resTo columns, and anything in between (please see DataVerseTable.png). I'll only be printing approved ones. I've also attached screenshots of how the calendar was built, and what items are currently being shown in the gallery.

[Kaiserfaust · Accepted solution]

Good afternoon Community,

I've since figured out my issue and it was a simple fix. Inserting the following function into the  "Items" property of my nested gallery did the trick.

Filter(
tabReservations,
resFrom < ThisItem.NextDay
And resTo >= ThisItem.Value
And resAppStatus = "Approved"
)

See screenshot "ReservationGallery.png" for reference. Hope this helps someone.