Forum Discussion
Dynamic Date Title
Hi, I want to insert years as a title into a card. Like shown in the picture. The last card "2022" is always this year. I did this with the formula "=NOW()" Each year the title should change to...
If you want a date you a year ago you can create the following measure:
Date a Year Ago = DATE(YEAR(TODAY())-1,MONTH(TODAY()), DAY(TODAY()))
If you want a date you a year ago you can create the following measure:
Date a Year Ago = DATE(YEAR(TODAY())-1,MONTH(TODAY()), DAY(TODAY()))
Awesome, this worked. Thank you very much to all of you!