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

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 ? 

      • PierrreVelraeds's avatar
        PierrreVelraeds
        Frequent Visitor
        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()))