Show information from previous month

Question

Hi everybody.

I´m building a workflow with shows me information that includes the current month (june by the time I´m writing this) but i need the information up to the last month

I know i could use somethin like "([month],-1,"month")" but not quite sure which function to use or even if it is better to use a "formula" or a "Filter"

Thank You.

neromerob · Accepted Answer

some told me to used this formula and for now is working

DateTimeAdd([month],-1,"month")

csmith11 · Accepted Answer

Here's another approach that uses the Union Tool to Handle the Field removal Step. What is filtered out is handled with a traditional filter tool applied to the Field Names.

This will not just filter out June 2022, but it will also filter out anything else after today's date. Once we move into July, June will be added back in.