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

[Kranthi_Kumar]

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]

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

[Kranthi_Kumar]

@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

[Aleksi_Alkio]

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.

[Aleksi_Alkio]

Maybe the OR is not needed

[Kranthi_Kumar]

@Aleksi_Alkio It worked thanks. Without the OR

[Pui_Yee_Tou]

Can explain further? dont really understand how the lookup works