Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic Day calculation based on week

Hi Guys, i have a complex scenario as explained below.

 

i want to pull a weekly report for employees who applied for no of days of WFH in a week.

i want to find this based on WFH applied dates.

 

can you please tell me what is the best approach to capture the no of days for the selected week?

 

from the below example is Out put1 or Out put2 is possibile? how to achieve both the outputs?

 

But we need to calculate the no of days only for the given week, an employee can apply wfh for multiple days but we need to count the days only for the given week based on the from and to date.

 

tamerj1 amitchandak Jihwan_Kim daXtreme Greg_Deckler Pragati11 mwegener 

parry2k lbendlin PaulDBrown 

Employee NumberApplied on From date To Date Expected Output 2WFH Date
1234520-08-202225-08-202226-08-2022 1234525-08-2022
3456725-08-202226-08-202231-08-2022 1234526-08-2022
8796922-08-202223-08-202206-09-2022 3456726-08-2022
     3456727-08-2022
Reporting week Aug 22nd to 26th    3456728-08-2022
Expected output 1    3456729-08-2022
     3456730-08-2022
Employee NumberNo of days of WFH applied for the week 3456731-08-2022
123452 Days   8796923-08-2022
345671 Day   8796924-08-2022
879694 Days   8796925-08-2022
     8796926-08-2022
     8796927-08-2022
     8796928-08-2022
     8796929-08-2022
     8796930-08-2022
     8796931-08-2022
     8796901-09-2022
     8796902-09-2022
     8796903-09-2022
     8796904-09-2022
     8796905-09-2022
Need Help

2 Replies