Hello guys,
I would like find an expression that give me the number of days until the end of the current month
Example (today 28 december, result--> 3 days to the end of december)
Solved! Go to Solution.
Need to wrap EOMONTH by DAY() as well.
DAY(EOMONTH(TODAY(), 0)) - DAY(TODAY())
Need to wrap EOMONTH by DAY() as well.
DAY(EOMONTH(TODAY(), 0)) - DAY(TODAY())
Thanks for the correction.
So, I probably overengineered the original draft expression. The following ought to suffice:
EOMONTH(TODAY(), 0) - TODAY()
Date minu date is always returning DURATION in AppSheet.
So your original expression of DAY(EOMONTH(TODAY(), 0)) - DAY(TODAY())
is going to be the right and compact expression to achieve a goal here.
Right--of course. Thanks for the additional correction!
So, my error wasn't overengineering, but rather replying too quickly--twice.
😄
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |