Skip to content

    • Charting

    Charting

    Dynamic date in dashboard textbox

    Member
    in Charting

    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.

     

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answer

    • Coach
      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:

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

      Yesterday.PNG

    Answers

    • Coach

      You haven't stated what's going wrong in your code ...

       

      maybe try wrapping date in a MAX() function 

      Jae Wilson
      Check out my 🎥 Domo Training YouTube Channel 👨‍💻

      **Say "Thanks" by clicking the ❤️ in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Coach
      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:

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

      Yesterday.PNG

    • Member

      Thanks @MichelleH this works great. Do you know if there a way to have the text all on one line instead of the date underneath the text.

       

       

      Capture.JPG

    • Member

      @MichelleH disregard my previous reply, it now ok with some formatting tweaks. ?

    • Coach

      Hi @Steve-DOMOnoob 

       

      Just remove the <br> HTML code in the CONCAT function

       

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Thanks @GrantSmith

    This discussion has been closed.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories