# Rollup Howto: Rows Created This Month? **URL:** \ **Category:** Ask for Help\ **Created:** [October 4, 2022, 10:31am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845 "2022-10-04T10:31:44Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [October 4, 2022, 10:31am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/1 "2022-10-04T10:31:44Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 4, 2022, 10:48am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/2 "2022-10-04T10:48:19Z")
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: ```auto 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. ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [October 4, 2022, 11:27am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/3 "2022-10-04T11:27:48Z")
You’re crazy fast + smart Darren! I’m going to try that out right away! Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 4, 2022, 11:29am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/4 "2022-10-04T11:29:06Z")
No, I’ve just traveled this road many times 😉 ---
**Author:** ![Daniel\_Gjode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/daniel_gjode/32/47347_2.png) [@Daniel\_Gjode](https://community.glideapps.com/u/Daniel_Gjode)\ **Post date:** [October 4, 2022, 11:39am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/5 "2022-10-04T11:39:21Z")
Haha! It worked like a charm. Your help is very appreciated 🙏 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 5, 2022, 11:39am UTC](https://community.glideapps.com/t/rollup-howto-rows-created-this-month/50845/6 "2022-10-05T11:39:37Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.