filtering with date range

[danaosjoin]

Hello,

I have loaded the following table with employees requested vacations.

The columns are : employee_code, from_date, to_date, days_requested

The data are:

1 06/11/2019 07/11/2019 2

2 4/11/2019 08/11/2019 5

I want to create a table to display the days_requested per employee by selecting from a filter pane date_from and date_to.

The problem is that when i select range 06/11/2019 - 07/11/2019 it will show only the first row but i want also the second line and instead of 5 days requested to show only the days between the selected range, again 2 days.

How can i do this ?

Thank you,

Noel

[StarinieriG]

Hi,

try to see file attached

[danaosjoin]

thank you very match 😊

[danaosjoin]

Hello

I have noticed in your example that if i do not select any dates from filter pane the computed column "days" you added is wrong because it must be showing the same days with "days_requested".

How can i rectify this ?

Thanks

Noel

[StarinieriG]

Hi,

you have to set the variable FROM as min instead of max, so it will work

[danaosjoin]

Hi,

I change it but again the result is wrong

Thank you

[StarinieriG]

Try to see file attached, here I see right numbers