I know that the answer for this question is easy to find on the internet, including this thread - but the suggested solution doesn't work for me.
I need to create a view in a Sharepoint online list, for items created "this year."
This should be possible to done by creating one calculated column "StartYear" with the formula =DATE(Year([Created]),1,1) and then another calculated column "EndYear" with the formula =DATE(Year([Created]),12,31), and then the view should get dates between these calculations.
However, when I try to create the calculated column, I get "Something went wrong - Syntax error".
Maybe, just maybe, this has to do with my SPO site being in Swedish. For example, I cannot use the [Me] but must use the Swedish [Jag] for filtering on current user.
I have tried to use Swedish and all different options, but the result is the same for =DATUM(År([Skapad]),1,1) =DATUM(År([Created]),1,1) =DATE(År([Created]),1,1) and so on
So maybe, the issue is something else.
Anyone got an idea?