Changing the month by itself

Hello, Parabola community of smart people! :smiley:

Wondering if you have a solution…

I have a flow that formats a spreadsheet to only show transactions that closed last month.

How I’m doing it now is hard coding that month in. For example, we’re in May (month 5) right now, so last month is April (month 4) and I edit my flow this month (and once every month) to change this number to 4:

Anybody have an idea on how to automate it?

Hey Cary!

Perhaps this would be a good place to use the Date Comparison step, and set the units to Months between your date and today. That should give you between 0 an 1 for dates in the current month, which you can then filter by.

Let me know if that is on track.

1 Like