Generate years in a row

[Jogi]

Hi, does anybody know the easiest way to get value

 let  vYears = '2019','2020','2021'

Thank you 

[AdiPai]

Hey Jogi ,

the below should provide you an idea of how this can be done -

Result 

[Jogi]

I need something like that : 

[anushree1]

what value are you looking for in case you want to generate the below yrs dynamically you could probably use:

let vYears =year(today())&','&year(AddYears(Today(),1))&','&year(AddYears(Today(),2));

[Jogi]

hey I still get just numbers, but I need years with quotation marks like '2019' ,'2020' ....an so on

[anushree1]

I do not understand the need in this requirement as you are representing year numbers using string.

But, you can get what you need by using the below statement:

let vYears =chr(39)&year(today())&chr(39)&','&chr(39)&year(AddYears(Today(),1))&chr(39)&','&chr(39)&year(AddYears(Today(),2))&chr(39)

[anushree1 · Accepted solution]

I do not understand the need in this requirement as you are representing year numbers using string.

But, you can get what you need by using the below statement:

let vYears =chr(39)&year(today())&chr(39)&','&chr(39)&year(AddYears(Today(),1))&chr(39)&','&chr(39)&year(AddYears(Today(),2))&chr(39);