Odd results with a Workdays count on an appointment field
At our school we are trying to calculate the workdays of a school term. We have a term start date field, we have a term end date field, and we have an appointment field that has the mid-term break range.
i tried:
workdays('Term Start Date', 'Term End Date') - workdays(start('Mid-Term Break'), endof('Mid-Term Break'))
But the workdays are 1 less than they should be.
if I leave out the mid-term break appointment subtraction then I get the correct workdays.
Is there some issue that I cannot use the appointment field to calculate workdays? Maybe because it includes hours and minutes?
2 replies
-
I'm pretty sure I'm not understanding some simple aspect here as this shouldn't be too culminated when the midterm break is usually only 3-5 days long and the work days should only be 1-3 days.
-
This is interesting. Pretty sure it is about start() and endod() are of type 'date/type' and have to be looked at real closely.
You can book a complemenary screensharing session with me using this link:
https://calendly.com/birger-hansen/15minBirger
Content aside
- 4 yrs agoLast active
- 2Replies
- 1024Views