Correct MONTHTODATE() for Gregorian calendar
Does anyone know how I can correct the MONTHTODATE() function when the model time is set to Weeks 5-4-4?
The function works perfectly apart from when the month changes during the week. With the current time settings, the second month cumulation starts earlier than it should because it is starting from the first day of the week in which the month has crossed over in rather than the 1st of the month.
Any help would be greatly appreciated.
As @rob_marshall has alluded to you need to map days into month time.
However, I would use a slightly different set of functions to populate the mapping.
You can then use MOVINGSUM to calculate MTD.1
This is what I have done in SYS Time module by day:
Basically, I use 15 as the day because that will always be in the "correct" month.
Hope this helps,
Hello @gazwillott ,
The function works alright in my case. I am not sure if you want the function to adopt the gregorian calendar, is it your expectation?
Amazing. Works a treat. Thanks very much 🙂0