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()))
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.

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

     

    • PierrreVelraeds's avatar
      PierrreVelraeds
      Frequent Visitor
      4 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        But with that solution I wont get the year 2021 in a date format right? Only in a number format ?