Skip to main content
Question

I want to create a variable in new view which would add every current year automatically into the table.Please help.

  • June 13, 2024
  • 2 replies
  • 15 views

apurva.patha12
Level 6
Forum|alt.badge.img
I want to create a variable in new view which would add every current year automatically into the table. Please help.

2 replies

rita.kiss12
Level 7
Forum|alt.badge.img+3
  • Level 7
  • June 17, 2024

What do you mean every current year? Current year is 2024.

You can use the YEAR(TODAY()) functions to retrieve it.

You can use this as column in the table or save it to the knowledge model.

What do you need the variable for?


apurva.patha12
Level 6
Forum|alt.badge.img

What do you mean every current year? Current year is 2024.

You can use the YEAR(TODAY()) functions to retrieve it.

You can use this as column in the table or save it to the knowledge model.

What do you need the variable for?

Hi Rita,

Thank u for suggestion.

Please see below photo of table.. there you can see column 2024 which is current year. i have added that year manually. Now my question is... next year which is 2025 should get add as current year into the table and accordingly previous year data should get subtract from current year. I do not want to do the changes manually when new year would get added into the table.

 

image