Hello,
I have this simple problem with filtering by date.
When I try to filter Date - is within - past year I also got records from this year.
Also If I try to filter Date - is within - past month I got only some of the records from the previous month.
What am I missing here, please?
Hi,
it's a common asked question, same as 'why it has "past month", "next month", but no "this month"?'
the real meaning of 'last year' is 'one year back from today (including)', 2022-02-16 - now(2023-02-16). Same for 'next year', but in forward direction. 'Week', 'month' working in the same way.
if you want to use some unit (month,week,year) in the meaning 'past month'='2023-01-01 - 2023-01-31', you need to add formula field for it.
Thank you. TBH, I'm pretty constrained by need of making those extra formulas in order to proceed with such basic operation, but your recommendation worked. Thank you 🙂
Hi,
it's a common asked question, same as 'why it has "past month", "next month", but no "this month"?'
the real meaning of 'last year' is 'one year back from today (including)', 2022-02-16 - now(2023-02-16). Same for 'next year', but in forward direction. 'Week', 'month' working in the same way.
if you want to use some unit (month,week,year) in the meaning 'past month'='2023-01-01 - 2023-01-31', you need to add formula field for it.
I suggest the Filter By options be renamed if they are not accurately representing what they are showing.
If I want to filter by "Last Month" that does not mean some arbitrary (31?) number of days before today. It means the records that have a date in the last month. Since you already have "the past number of days" then "last month" is redundant.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
