I’m trying to create a rollup / count of rows created within “current month”.
I have a field where I save “date created” but I can’t figure out the math needed to count the rows added within the current month?
A few different ways you could do this.
One of the simplest would be to use the month and year number. Create two math columns using the formula Year(Date)*100 + Month(Date). One using the current date/time and another using your record dates. Then you can compare the two math columns with an if-then-else column, and do a rollup on that column to get a count.
Another way would be to first use a math column to determine midnight on the first day of the current month:
N+1-DAY(N)-HOUR(N)/24-MINUTE(N)/1440-SECOND(N)/86400
…where N is the current date/time. Then compare that to each record date. If the record date is after the first day of this month, then it’s in the current month. Then do a rollup as per the first option.
And yet one more way would be to create the math columns as per the first example, but instead of using the if-then-else column, create a multiple relation that matches your current date/time math column to your record dates math column. And then do a rollup through that relation.
4 Likes
You’re crazy fast + smart Darren! I’m going to try that out right away! Thanks
No, I’ve just traveled this road many times 
Haha! It worked like a charm. Your help is very appreciated 
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.