I am calculating deadlines by using a dynamic formula in MagicETL, which adds 4 days to a date like so:
CASE WHEN `issue` = 'bug' THEN (
CASE
WHEN `priority` = 1 THEN ADDDATE(`CreationDate`, INTERVAL 4 DAY)
END
)
This works great, however I'm wondering how I could change the interval to simply be four business days instead of four calendar days.
I see in the documentation that there is a page for calculating business days between two dates - https://domohelp.domo.com/hc/en-us/articles/360043428153-Date-Difference-for-Business-Days but it doesn't cover adding business days to a date.
I also see within MagicETL, there is a date operations which allows us to use a "Add to date" operation but business days is not a unit of measurement. Any ideas on how I could update the case statement to be 4 business days rather than calendar? Thanks a lot!