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
Super 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

I dont have a column, I just have this formula. I created it manually as a measure and wanted to insert it into one card.