can you provide a screenshot?
Yep, this is how to do it. Select Advanced Filters and it will default to starting a default filter on the âWhereâ line, then select your Column > Date, Select âis betweenâ, then select your exact dates from a calendar view. Perfecto!
this would mean you have to constantly change these two specific dates. Instead a function like âfrom 5 days ago to 5 days from nowâ would be great.
There seams to be something similar by using the âlast week/next weekâ filters. However they filter out everything that has a timeline which is longer than the timeframe. E.g. started 2 weeks ago but is still ongoing.
Try adding âcurrentâ as an additional OR statement in your filter
What exactly do you mean? Is there a native filter named âcurrentâ? Or do you write a function for a formular-column?
If you select the advanced filter option and then timeline there are a number of pre-defined settings that you can choose from e.g. Done on Time, Overdue, Current etc. I am not sure if these are specific to the subscription package you are using.
I can see the options. However the do - as so often - have trouble with subitems. But thank you
I need this really really badly! We want to track budgetary items, but without being able to sort or search by date, it takes an act of god to figure out what we spent in a given month.
From using MS Access, Caspio etc I expected to find more flexible filters like âSince X days agoâ. The absence of these filters means that we will not be signing up to Monday.
I just want to filter out all done items and subitems.
Please make this possible.
Adding âcurrent yearâ and âlast yearâ would be great as well, we often do report on the current year and compare to last year.