Hey,
I need to filter in the inline list (modo calendar) only the current month, how do I do it?
Put this formula on row 1 of a column on your sheet. Change the F2:F to the column you have your date in. Then filter on this column.
={"ThisMonth";ARRAYFORMULA(IF(LEN(F2:F),month(F2:F)=month(today()),""))}
Great!!, tks George
Thanks George. This works great!!
George,
How would I modify this formula for the current date instead of the month? Thanks
I haven’t tested it but I’m pretty sure… just take out both occurrences of the word month.
Well that was simple. I tried everything but that. Thanks it works perfectly
Glide also has built in filtering to compare dates to Today…in case you are interested in a non formula solution.