Dynamic date in dashboard textbox

Reply
Highlighted
White Belt

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.

 


Accepted Solutions
Highlighted
Green Belt

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

View solution in original post


All Replies
Highlighted
Black Belt

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 heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Highlighted
Green Belt

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

View solution in original post

Highlighted
White Belt

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

Highlighted
White Belt

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

Highlighted
Red Belt

Hi @Steve-DOMOnoob 

 

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

 



**Was this post helpful? Click the heart icon**

**Did this solve your problem? Accept it as a solution!**
Highlighted
White Belt

Thanks @GrantSmith

Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.