topic Re: filtering with date range in App Development

filtering with date range

danaosjoin — Tue, 05 Nov 2019 09:57:04 GMT

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

Re: filtering with date range

StarinieriG — Tue, 05 Nov 2019 11:20:47 GMT

Hi,

try to see file attached

Re: filtering with date range

danaosjoin — Tue, 05 Nov 2019 11:48:08 GMT

thank you very match 😊

Re: filtering with date range

danaosjoin — Thu, 07 Nov 2019 07:38:28 GMT

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

Re: filtering with date range

StarinieriG — Thu, 07 Nov 2019 08:29:46 GMT

Hi,

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

Re: filtering with date range

danaosjoin — Thu, 07 Nov 2019 10:49:26 GMT

Hi,

I change it but again the result is wrong

Thank you

Re: filtering with date range

StarinieriG — Thu, 07 Nov 2019 11:04:11 GMT

Try to see file attached, here I see right numbers