Calculate the number of Business Days in the current calendar year
I need help with a formula I am trying to use in my ETL to calculate how many business days there have been YTD. I was using this and it seemed to work, however, it is now returning a result of 1. Can anyone assist? (DATEDIFF(DATE(CURRENT_DATE()),DATE(CONCAT(DATE_FORMAT(CURRENT_DATE(),'%Y-%m-'),'01'))) -…
