Filter items created last month

Hello everyone.

I am trying to filter by Creation date where it will always be the last month.

So if this month is march it filter all the items created in february. If in may should filter all the items created in april.

Then, this filter should always return the previous month.

How could I do this approach?

I have tried doing current date/time extract month - item.creation date but it does not work.
:slight_smile:

1 Like

Hi there, @anon19893928… to do what you described, the following constraints should do the trick.

Creation date >= Current date/time:rounded down to month +(months): -1

Creation date < Current date/time:rounded down to month

Hope this helps.

Best…
Mike

3 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.