adamxor Member

Discussions

    • Data Interval Using Business Days In MagicETL

      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…

    • Adding business days to a date via MagicETL

      Hi, I'm currently calculating a deadline using a dynamic formula in MagicETL. It looks like this: CASE WHEN `issue` = 'bug' THEN ( CASE WHEN `priority` = 1 THEN ADDDATE(`CreationDate`, INTERVAL 4 DAY) END ) The calculation works great, but I was wondering what would be the best way to update it to 4 business days, rather…

Default Avatar