Working Days excluding first date

Discuss your general Proclaim related queries here.
Post Reply
kettleashlee
Posts: 12
Joined: Fri Jun 01, 2018 12:16 pm
Has thanked: 4 times

Working Days excluding first date

Post by kettleashlee » Tue Apr 09, 2019 7:31 am

Hi All,

You helped a while back with creating a "working days" maths to calculate the amount of working days between 2 dates and it worked great. They have decided now that they don't want the first date included in the calculation. this is what we have so far:

v-date = {Report Instruction received.Date}
v-days = {Time between report ins & sent to sol.Number}
v-weekday = 0
count = 0
WHILE count < v-days DO
v-date = v-date +1
dayofweek = WEEKDAY( v-date )
IF dayofweek = "Saturday" OR dayofweek = "Sunday" THEN
ELSE
v-weekday = v-weekday +1
END
count = count +1
END
result = v-weekday

The dates i was working with included the bank holidays too and excluded them from the calulation, i basically want it to not count the report instruction date and start counting from the next working day. Any suggestions?

Thanks

Post Reply