Visitor dashboard

[harry24]

I have visitor dashboard, which fetches count of daily visitors. The filter condition that I have added is arrival date= today . This works fine if arrival and departure date is same . But if arrival date is today and departure is after 2 days then in the dashboard it shows visit only on first day and not for remaining days. How to write filter condition for this

[Zach Koch]

In most condition builder filters, if you are choosing a date, you have access to different lengths of time. You can change the filter to fit your needs. Here is an example of a date that is today or in the future. If you need the query in code form, create the query in the Condition Builder, then right click it and click Copy Query

[harry24]

This is not opened date , this is visitors visit date .

In visitor_ registration table we have two fields arrival_date and departure_date

[Zach Koch]

I was using opened date as an example, you would insert the fields you need from your table.

[harry24]

This does not work