Show information from previous month

[neromerob]

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. 

[CarliE]

Hi @neromerob,

You can use a Dynamic Select for this with this formula 

!contains([Name],DateTimeFormat(DateTimeToday(),"%B"))

What this formula is doing is saying, do not select anything that contains the month name for the month of today. Attached the workflow- I don't have data in here, but you will see how the June field is removed.

If this solved your issue, please make sure to mark this as a solution :)

Thanks!

[IraWatt]

Hey @neromerob,

Can you provide a sample data set try solutions on?

[neromerob · Accepted solution]

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

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

[csmith11 · Accepted solution]

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.