I have an issue with usersettings.
I want to have a setting of a specific date - always the last october, 1st .
I detected that year(today()) returns the year as number with thousand seperator and there is no possibility to inhibit that. So i used a formula in initial value as follows: =IF ( MONTH(TODAY())>9 , “10/01/” & SUBSTITUTE(TEXT(YEAR(Today())),",","") , “10/01/” & SUBSTITUTE(TEXT(YEAR(Today())-1),",",""))
But the seperator is different on different devices. Comma and dot are possible. This means my formula does not work.
Any idea on that?