EnumList without thousands separator

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.
image

image

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

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?

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

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

Awesome @Steve thank you very much!

1 Like