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.
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)
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |