AnsweredAssumed Answered

Determine the number of weeks in the current month

Question asked by ben2017 on Apr 13, 2018
Latest reply on Apr 13, 2018 by philmodjunk

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.

 

Thanks! 

Outcomes