Dynamic date in dashboard textbox

Hi,

I need some help in creating a dynamic date in a dashboard text box. i'm looking for the date to display yesterdays date. 

Also can this dynamic date be used for a summary number in a text box?

Any guidance would be greatly appreciated.

 

Best Answer

  • MichelleH
    MichelleH 🟠
    Accepted Answer

    You could use a CONCAT function in a Textbox card to display the date in whatever format you'd like. For example, this code will give you the output below:

    CONCAT('Yesterday: <br>',DATE_FORMAT(DATE_SUB(CURDATE(),interval 1 day),'%m / %d / %Y'))

    Yesterday.PNG

Answers

This discussion has been closed.