Only see certain results of current month


I only require values from current month to show up,

How can I achieve that

0 17 1,054
17 REPLIES 17

AlexM
Participant V

you can create a slice with the condition [Date]=MONTH(TODAY()) and then select the slice as a source for the view.

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

Thankyou very much

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

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

See also:

Hello Steve,

So what you are saying is I need to extract month from [Date] and then compare with MONTH(TODAY())

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

Thanks but it did not work

Please try again. There were missing parentheses.
AND (

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

)

Perfect Thankyou very much

Try

MONTH([Date])=MONTH(TODAY())

But doing this will only allow you to check for the same year. If the data is in multiple years, you might want to append the year value as well. Something along the line of:

YEAR([Date])&MONTH([Date])=YEAR(TODAY())&MONTH(TODAY())



Simpler:

EOMONTH([Date], 0) = EOMONTH(TODAY(), 0)
Top Labels in this Space