6 Replies Latest reply on Apr 4, 2018 12:55 AM by Tamas Tyukos

    Change date to today

    Tamas Tyukos

      Hi community,

       

      Currently I am facing a problem, which might be easy for you, as I am still learning Tableau. I have data, which look similar as you can see below. I have IDs with different dates, and I would like to change the latest date to today's date.

       

      I tried something like this, but this changes all the date to today, which is not good for me: If [date] < TODAY() THEN TODAY() END

       

       

      IDDateSolution
      12018.01.052018.04.03
      12018.01.042018.01.04
      12017.12.152017.12.15
      12017.11.012017.11.01
      12017.10.152017.10.15
      22018.02.142018.04.03
      22017.11.012017.11.01
      22017.10.082017.10.08

       

      Any help is appreciated!

       

      Added red row, as my problem description was confusing

       

      Message was edited by: Tamas Tyukos