Has anyone implemented YTD, MTD and WTD calculations using the 4-5-4 Retail Calendar? See picture for the first quarter of 2019 dates and the corresponding dates for 2020. The biggest issue I see (maybe I am wrong) is the first date of the year changes every year.
Sam covers this in the Time-Intelligence Mini-Series module. You cannot use the built in time intelligence functions and need to have a detailed Calendar table and then you can explicitly write out the function, but the the module covers all of that.
