Hi, anyone help me with the logic on how you would work this out?
I am charging the value of several items per week (Mon-Fri). I have a summary field showing a running total cost, from the date out 'till right now.
What I'd like is to have another total showing the cost occurred but only for current month. So I need to work out how many weeks this month has then use this to sum the cost of the items per week x the number of weeks. Just can't figure out how to get the number of weeks part.