Filtering the date as in write query

Filtering the date as in write query

Hi Zoho Team,

iam experiencing to cannot resolve how to filtering the date as in Query as below 
e.g date filter in query
"2022-02-01 between Date_Arrive and Date_Depart OR 2022-02-05 between Date_Arrive and Date_Depart"
in this filtering we can have all booking detail regarding Date_Arrival and Date_Depart in between

Please advise how to achive this date filtering in user filtering in Dashboard / chart view

waiting for your feedback and solution

Thank you

Regards
Abu Bakar
Karma Group