Last years end, a "minus" problem

AppSheet AppSheet Q&A
,
1

Hi all,

What should this formula be yielding?
EOMONTH(TODAY(), -MONTH(TODAY()))

December 31, Last (2025) year, right?

Why is producing DEC-31 2026?

  • because we are in June and AppSheet parser is omitting the minus “-” before MONTH function

Why do I have to write EOMONTH(TODAY(), -1 * MONTH(TODAY())) for it to work properly?

Why is the simple - being ignored? Has anyone else run into this quirk?

2

The library AppSheet uses for expression parsing is designed for Excel formulas. AppSheet has adapted it for expressions. There are some expressions it may not handle properly. This may be one.

3

Yes your observation is correct and it should work as it is, the way you have coded above. Definitely it is a bug and that edge test case is not handled by the function.

Another variation that works is putting the second argument in parenthesis. The following variation works.

EOMONTH(TODAY(), -(MONTH(TODAY())))