My table has data for April 1, 2020 in it. I set a filter on the field Open Date is Last Month and no data returns. If I set the filter to Last Quarter the April 2020 data shows. Is Last Month looking 30 days back from today or is it truly looking back at last calendar month from today?
Hello Kerry Wright!
To quickly answer your question, 'Last Month' is defined as:
Month—A month is defined according to the Gregorian calendar. Each month starts at 12:00:00 a.m. (local time) on the first day of the month and continues until 11:59:59 p.m. (local time) on the last day of the month.