Solved: APP expense - Page 2

Cannone_Cannone · 11-07-2021 08:40 AM

Hello to all!!!
I have a little problem, I created an application for my monthly expenses,
the entry of expense data is made by two different people.
so I created a “total” view that gives me both people’s expense totals.
In this view, how can I see only the expenses of the current month? and not those of the past months?
Thanks

Steve

Try this as your slice row filter expression:

(EOMONTH([date-from-row], 0) = EOMONTH(TODAY(), 0))

Replace date-from-row with the name of the column that contains the date for each row.

The EOMONTH() function calculates the date of the last day of the month represented by the given date. If the date from the row and today’s date both produce the same last-day-of-the-month date, they’re both in the same month.

View solution in original post