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()))
Hi Anonymous,
13-7-1905 is the date value of number 2021. You can see this e.g. in Excel by changing the format into Short Date of a cell containing 2021.
I can reproduce the behaviour you experience when I create a new column instead of a measure
Defintions:
- Column Last Year = year(Today()) -1
- Last Year = year(Today()) -1
Solution is then to create a measure with that definition.
But with that solution I wont get the year 2021 in a date format right? Only in a number format ?
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!