Formula to pull previous month data

Question

Hi,

I am looking for a formula to get previous month data. I want to automate it so whenever I run the workflow it should only return previous month data.

For example, if I run it today(9/22/2021), I want all the data from 8/1/2021-8/31/2021.

When I run it in October then I want data from 9/1/2021-9/30/2021. The number of days might be 30 or 31 depending on the month but I need all the data from previous month. Any help on this would be great!

Thank you in advance!

cmosz · Answer

I was looking for the same thing and this worked for me. I just had to change the [Date] field to be a separate [Effective Date] field that I needed to measure by. Thank you so much for this! : )

atcodedog05 · Answer

Hi @aparna0208

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

aparna0208 · Answer

@atcodedog05 Thanks for your inputs. I tried both formulas on sample file that includes data for all months. I removed text input tool and instead substituted my excel file and then ran it. I just tried on August month data by running it as of today. I expected to get all data from 8/1-8/31 but both formulas didn't work. Also, that file includes all data starting from Jan and wasn't sure how to test that by going back in time like April and see if I get data for March.