Is there a way to filter a date range. I've t...

(Kranthi Kumar) #1

Is there a way to filter a date range. I’ve two columns for dates [From] and [To]. Now the user selects a date to see if the venue is available for a specific date.

What i would like to do is, say if an event has been booked from 1st June till 5th June, when the user selects the date 2nd June this event should also be displayed in the slice. Basically, user should be able to see any event that is booked on that date. Is there any way to filter for a date range instead of just the date?

(Aleksi Alkio) #2

May I ask first from where the user selects the date? Does he add that date into a record?

(Kranthi Kumar) #3

@Aleksi_Alkio There will be two sections in a dashboard. One will have a date field and the other has a slice which displays records based on the date selected in the first section

(Kranthi Kumar) #4
(Aleksi Alkio) #5

You need to use AND expression like…

OR( AND([from]<=LOOKUP(…), [To]>=LOOKUP(…)), [From]=LOOKUP(…), [To]=LOOKUP(…)). With the LOOKUP you need to read the existing Date value.

1 Like
(Aleksi Alkio) #6

Maybe the OR is not needed

(Kranthi Kumar) #7

@Aleksi_Alkio It worked thanks. Without the OR