I have an app that needs to roll up different values for a dashboard section. Fx how much money each individual has logged in the past 3 months: This month $ A Last month $ B Two months ago $ C Three months ago $ D I have this month figured out by having a …

[image] KPT: My problem is when it’s comes to Jan, Feb and March and I need to also change the year and add to the month rather than substracting? A simple way to deal with this would be to adjust your Math formula as follows: Year(Date) * 12 + Month(Date) The resultant number won’t be inst…

[image] Can we add add a entire year into a trigger action Ask for Help I actually have an updated version of that formula, which I think takes care of a couple of odd issues when adding months to a date that results in the end of February. Probably doesn’t matter for you…

I’m trying to wrap my head around your fomulars in: [image] If then else with DATE @Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The same place that Darren got that original formula had a second formula. It looks like that old thread is unlisted now…

My formula results in a date. When you place it in a math column, it should ask for two parameters, a Date, which you can replace with Now or any other date column you have…and the Months parameter, which is the number of months you want to add or subtract from that date. You could replace Months …

Thats a great solution - thank you Is there a way to do similar with days. So to check if something is yesterday or four days ago?

That might be tricky since the number of days in a month can vary. There will always be 12 months in a year, but you will never have a consistent number of days in a month. Instead, simple math can give you the number of days. just subtract a date from Now in a math column to get the number of da…

[image] Jeff_Hager: simple math can give you the number of days. just subtract a date from Now in a math column to get the number of days between the two dates. Probably worth noting that by default that will give you a duration (hh:mm:ss), so to return the number of days you need to wrap it …

Is rolling up summary values based on dates - is there an easier way to do this?

Ask for Help

Jeff_Hager October 25, 2022, 11:11am 2

Topic		Replies	Views
Find the last day of the following month Ask for Help holdmybeer	47	3316	January 17, 2024
Date math - 3 months from a specific date Ask for Help	9	970	July 20, 2022
Show the total monthly sales per user Ask for Help	10	411	June 24, 2023
Help colum math Ask for Help	10	520	May 7, 2022
If then else with DATE Ask for Help	28	3345	May 25, 2022

Is rolling up summary values based on dates - is there an easier way to do this?

Related topics