How to change date fomat in the Data view

madhukiranreddy
madhukiranreddy Member
in Cards, Dashboards, Stories
image.png


I m viewing the data from snowflake inside my dodmo dashboard.

when i clcick on data, i see the above, But i want to use different date format.

Can someone help

Answers

  • Data_Devon
    Data_Devon Contributor

    Your best bet will be a transformation in Magic ETL or through a Beastmode, but it depends on your end goal.

    If using this while building a card in Analyzer, you can use Beastmode and this code to achieve it:

    DATE_FORMAT(BIRTH_DATE,'%m/%d/%Y')

    If you can access Magic ETL, then you'll just use that same formula above within the Utility tile of "Add Formula"

    image.png

    Let us know if this helps!

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

  • MarkSnodgrass
    MarkSnodgrass Coach
    edited February 10

    That is just how dates a displayed when viewing dates in the data center. Build a card to view the date in a format that is more to your preference. Click on the Cards tab next to Data and create a table card. When you add a date field to the table card, you can configure how you want it displayed.

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories