Calender Type

awebber10

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. 

 

awebber10

Excellent - thank you for your swift response