Hi all, I have created a model in which the calendar type is weeks: 4-4-5, 4-5-4 or 5-4-4 and grouped it by 4-4-5. I now need to prepare a report which shows the month to date totals of my line items. At the moment I am unable to do this with the monthtodate formula because when calculating Octobers month to date for example it will include 29-30 September as under the format it is treated in the same month. I need to be able to calculate the month to date purely for October i.e. 1-31. How do I solve this problem? Any thoughts or help would be greatly appreciated.
... View more