Blog Post
UrsulaLlaveria
6 years agoQrew Assistant Captain
I completely agree with the holidays thing! My team just last week had to write a script to account for all holidays in a duration field. Would have been so much more efficient if this was included as a formula type in QB.
------------------------------
Ursula
------------------------------
------------------------------
Ursula
------------------------------
DwightMunson1
6 years agoQrew Assistant Captain
We have a table dedicated to years and the holidays within them. We have to relate them to any table where we need to account for holidays in two steps, Holiday for Current Year and Holidays for Next Year. So since we have 6 holidays, that's 14 related fields, plus we have some placeholders for if we add a holiday or two.
Then we declare a variable to account for the holidays in any formula date fields.
------------------------------
Dwight Munson
------------------------------
Then we declare a variable to account for the holidays in any formula date fields.
------------------------------
Dwight Munson
------------------------------