You’re offline. This is a read only version of the page.
26
Hi Everyone I am hoping someone can help me. I have a Gallery with a column called "Session 1". This column will have one or two dates per school. At the top of my screen I have two date fields and I am wanting to filter dates based on the From and To dates but not sure how to do it.
My current Formula in the items property of the Gallery is as follows:
SortByColumns(AddColumns( 'Scheduler Tracker', "myDate", LookUp(Bookings, Location = SchoolNameAddress && Session = "Session1").Date), "myDate",Ascending)
If you're wanting to filter that list, you'll want to put Filter() around 'Scheduler Tracker'
Something like this:
Filter('Scheduler Tracker', Session1 >= FromDate.SelectedDate && Session1 <= ToDate.SelectedDate)
Share
Report
All responses (
Answers (
