Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • PierrreVelraeds's avatar
    PierrreVelraeds
    4 years ago

    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()))
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
4 years ago

Anonymous  Can you share screen shot of your date column and check which data type it is. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

In the first picture you can see the formula "today" with the today date.

And in the 2. picture with "year(today)" i get the year 1905.