Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how to automatically set today's date

Hi Community, I have a very simple table with only one cell value which is today's date.  Is there a way to make the date automatically update to the current date?  Basically the same as if I were to use the =today() function in excel.  Thanks!

 

 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Why does it have to be a table?

     

    Could it not be a measure? e.g. Today_Date = TODAY()

     

    Thanks

  • Petazo's avatar
    Petazo
    6 years ago

    Hello:

    I give you two ways below

    Today's date to measure, you first create a measure, and then formulate it.

    fecha hoy en medida.png

    In table, you add a new table and then the formula

    fecha hoy en tabla.png

    I hope it works for you.

    Best regards.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Why does it have to be a table?

     

    Could it not be a measure? e.g. Today_Date = TODAY()

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thanks!  no reason it has to be in a table, i just didn't think about doing a measure.  appreciate your help!

  • Petazo's avatar
    Petazo
    Icon for Helper I rankHelper I
    6 years ago

    Hello:

    I give you two ways below

    Today's date to measure, you first create a measure, and then formulate it.

    fecha hoy en medida.png

    In table, you add a new table and then the formula

    fecha hoy en tabla.png

    I hope it works for you.

    Best regards.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you!!  both solutions worked great.