How to Show only Current Month data

[Muhammed_Aadhil]

I want to Show only the current month data on the table

I tried adding =MONTH(TODAY()) but it didn’t work

How can i do this?

[LeventK]

You need to create a Slice with below expression:

MONTH([DateColumnName]) = MONTH(TODAY())

[Muhammed_Aadhil]

Sorry I didn’t understand the meaning of Slice, I’m new to appSheet.

I added your forumla and I’m getting the following error.

[LeventK · Accepted solution]

Have you considered reading some help docs?

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[herrwieting]

The data then mixes with those from last year! How can I fix this?

[Suvrutt_Gurjar]

If you are looking for data of current month in the current year, you could try 

EOMONTH(TODAY())= EOMONTH([Date])

EOMONTH() - AppSheet Help