sql script
I don't understand why the following script and screenshot above is showing the 'MONTH' column as not being recognized. This is clearly not a table column and it is an input for the function.
--- Check for next months accounting day
SELECT *
FROM CI_MISSION_CONTROL_DM_PROD_DB.MASTER.MDM_CALENDAR_V1_VW
WHERE DAY_DATE BETWEEN DATEADD(MONTH, 1, DATE_TRUNC('MONTH', CURRENT_DATE()))
AND DATEADD(DAY, -1, DATEADD(MONTH, 2, DATE_TRUNC('MONTH', CURRENT_DATE())))
AND WORKDAY_DESCRIPTION = 'Accounting Day'
AND WORKDAY_NUMBER = 8;