How do I substract months from a date?

[François21]

I can't substract months from a date stored in a column using EOMONTH. I'm afraid it is due to the locale settings (My locale settings are in France ; I've checked both Sheet and AppSheet settings) :

For examples, if [myDate]=01/01/2024, then :

EOMONTH([myDate], 2) = 31/03/2024, that's correct
EOMONTH([myDate], -1) = display an error : "The added or subtracted value results in an un-representable DateTime. Parameter name: months"

These formulas works perfectly when I change [myDate] by a value as "1/1/2024" or "01/01/2024" like :
EOMONTH("1/1/2024", -2) = 30/11/2023

Is it really due to the locale settings? How to resolve it?

[Steve]

This could be a bug with locale support. Please contact AppSheet Support for help with this.

Attn @Aleksi @Rob_Just

[drlchurch]

I am having the same issue with US locale so I don't think it has to do with locale settings. I am trying to get the first day of the month of a date column with EOMONTH([Date In], -1) and I receive the same error "Error: The added or subtracted value results in an un-representable DateTime. (Parameter 'months')". [Date In] is a Date type, not DateTime. And my dates are formatted MM/DD/YYYY so I don't think it has to do with the date format.