Weird EOMONTH() Behavior! Bug!?

AppSheet AppSheet Q&A
,
1

Hello People,
I’m having a weird behavior from the EOMONTH() formula, and I’m not sure if its me or a bug!

Simply, I’m having three columns, [StartDate], [PeriodInMonth] and [AutoEndDate] where the latter has the formula:

EOMONTH([_THISROW].[StartDate], [_THISROW].[PeriodInMonth])

When creating a new row, I input the [StartDate], then input [PeriodInMonth], then formula calculates correctly, but it says “Invalid Entry” in red! Yet, if I simply ‘Edit’ the formula, literally change nothing, and just hit ‘save’ the issue goes away! Weird!

I though its a ‘type’ problem, but my assigned types seem correct. Please check the screen shots

  1. The columns

3imad_Zaynedin_0-1675372418276.png
3imad_Zaynedin_0-1675372418276.png1318×346 22.7 KB

  1. The Formula

3imad_Zaynedin_1-1675372469973.png
3imad_Zaynedin_1-1675372469973.png1387×428 29.9 KB

  1. The ‘Invalid Entry’

3imad_Zaynedin_0-1675373045868.png
3imad_Zaynedin_0-1675373045868.png500×479 13.3 KB

  1. Simply edit formula, change nothing, and save, no more issue!!

3imad_Zaynedin_1-1675373085763.png
3imad_Zaynedin_1-1675373085763.png509×466 11.7 KB

Weird right? Or am i doing something wrong?
In advance, thanks for your insights

2

Remove both instances of [_THISROW] from your expression. [_THISROW] is only necessary when you change context, like with a SELECT. Using it when not necessary can cause issues.

3 Likes
3

Thanks. This solved the issue

1 Like