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()))
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous ,measure or column as per need

 

This Year = year(Today())

 

Next Year = year(Today()) +1

 

Last Year = year(Today()) -1

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for your fast reply.
    But I still get strangely 1905 for the last year. 

    • 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.