Only see certain results of current month


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.

5 Likes

Hello Alex
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

3 Likes

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.

3 Likes

Thankyou very much

1 Like

Thankyou

1 Like

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?

Yes

This is not a correct expression. [Date] is a Date value, MONTH(TODAY()) is a Number value.

See also:

2 Likes

Hello Steve,

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.
AND (

YEAR( [DUE DATE] ) = YEAR( TODAY() ), MONTH( [DUE DATE] ) =MONTH(TODAY())

)

3 Likes

Perfect Thankyou very much

3 Likes