I only require values from current month to show up,
How can I achieve that
you can create a slice with the condition [Date]=MONTH(TODAY()) and then select the slice as a source for the view.
Many thanks for your reply
Can you please let me know how I exactly I can do that. I am a bit new to Appsheet
Go to Data o the side tab and there you will see at the top Slices.
Click on New Slice.
Name your slice.
Select the source table.
At row filter condition you write the formula [your column that store the date]=MONTH(TODAY())
Then you go to UX side tab.
Go to To Do List view and select your slice under For this data.
The slice will be at the very bottom of the dropdown list.
A slice is a filtered table of your table.
By adding a row filter condition, it will only display the records that match that condition.
That means you can have a slice for last month, for next month, for this week, and so on.
Thankyou very much
There seems to be something wrong with my formula. I am choosing three different dates two are in Feb and the third is in march but all the results are coming as Y
is this formula in the slice condition?
This is not a correct expression.
[Date] is a Date value,
MONTH(TODAY()) is a Number value.
So what you are saying is I need to extract month from [Date] and then compare with MONTH(TODAY())
Thanks but it did not work
Please try again. There were missing parentheses.
YEAR( [DUE DATE] ) = YEAR( TODAY() ), MONTH( [DUE DATE] ) =MONTH(TODAY())
Perfect Thankyou very much