This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
That formula doesn't account for the year of the data so it will take take from the previous month of last year too. It won't work during January either when the current month is 1 - previous month 12.
Here is another formula I tried that should work for those situations.
I have the field [date closed] that has dates in it. I need to have the formula to pull only the previous month. As today is 07/28/2018 I need data 06/01/2018-06/30/2018. When I put the formula [Date Closed] <=ToDate(DateTimeAdd(DateTimeFirstOfMonth(),-1,”days”)) and ToDate >=(DateTimeAdd(DateTimeFirstOfMonth(),-1,”month”)) The error comes : unknown function ToDate