Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I have an issue , I want to sum numbers of days between "Date absence" , Example
employe 349 : ( ("08-02-2018" - "01-02-2018") = 7days + ("13-02-2018" - "08-02-2018") = 5days) = 12days
employe 395 : ("16-02-2018" - "15-02-2018") = 1days
employe 433 : ("27-02-2018" - "26-02-2018") = 1days
employe 533 : ("15-02-2018" - "14-02-2018") = 1days
What I want to have report in one TEXT BOX the sum of this values .... then 15 days
How I can do this ? THANKS SO MUCH
Hi,
Calculate the days difference in the script level.
if(Absence_Emp=Peek(Absence_Emp),Date_Absence- Peek(Date_Absence),0) as Days_diff
Directly use Sum(Days_diff) in the Text box.
as far as i know, use of Above function directly won't work in Text box.
Thanks,
Pooja
Hi Steeven,
Please find attached.
Br,
KC