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
Solved! Go to Solution.
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.
Also. It would make sense to have just one table and an extra column/field called โuserโ that logs the USEREMAIL()
or something like that
Thanks a lot for your reply, if i create a slice view, what formula i have to do insert for see only date of current month?
It depends on what โcurrent monthโ means to you.
For example, I almost always show data thatโs 28 or 30 days old. Thatโs my โmonthโ.
But, you could also show the data that is inside the month as of what the calendar says.
Check this
sorry but i still donโt understand, i tried to look at the links but i canโt understand.
for example, when the month of December arrives, I want to view only the data that I entered in December and no longer those of November
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.
PERFECT!!!
Thanks a lot!!
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |