I am looking for a formula that will return data from the previous month. I know I could use a simple filter tool and define my dates each month, but I would like to automate the process so it's always looking back at the previous months data.
Example: Today is 6/6/2018, I would like all data from 5/1/2018-5/31/2018
In 2 months (8/6/2018), I would like data from 7/1/2018-7/31/2018
Solved! Go to Solution.
This was very helpful. Thank you.
This was the solution I was looking for. However, was wondering if you have a code for in-db?
Thanks,
Peter
Hi all, sorry a newbie but I am still returning the previous years using
ToNumber(DateTimeMonth(DateTimeToday()))-Tonumber(DateTimeMonth([date]))=1