EnumList without thousands separator

[Fabian_Weller]

In an EnumList I always want to have two options:

• The actual year
• The next year

If I hardcode it with the Base type “Number”, I get thousands separator.

I don’t like them, so I have to use Base type “Text”

Now it’s clear that I want to use an expression to calculate those two years.
So I tried this expression in the “Suggested_Values”:

LIST(
  YEAR(TODAY()),
  YEAR(TODAY())+1
)

But no matter if I use Base type Text or Number, I will get this Error:
Column Name ... has invalid 'Suggested Values' of '=LIST( YEAR(TODAY()), YEAR(TODAY())+1 )'. The type of the Suggested Values does not match the column type.

So the only way I could do this was:

• EnumList
• Base type Text (to get rid of the thousands separator)
• And this expression in Suggested_Values

LIST(
  "20"&TEXT(TODAY(),"YY"),
  "20"&(NUMBER(TEXT(TODAY(),"YY"))+1)
)

• Or

LIST(
  TEXT(TODAY(),"YYYY"),
  TEXT(TODAY()+365,"YYYY")
)

Because as soon as I use the full year and add 1 (2021+1) I will get thousands separator.

Does anyone have a smarter solution?

[Steve · Accepted solution]

Your approach is a good one, though I might instead use:

LIST(
  ("" & YEAR(TODAY())),
  ("" & (YEAR(TODAY()) + 1))
)

[Fabian_Weller]

Awesome @Steve thank you very much!