Remove time stamp from date format

Options
Valeriehern
Valeriehern Member
in Charting

Hello,

 

If I have a date format that includes month, day, year, hour, minute, second, as follows: 

21-Apr-16 1:53:46

 

What is the Date_Format in Beast Mode to only get the "Mon, Day, Year"?

 

Thank you.

Best Answers

Answers

  • Godzilla
    Godzilla Contributor
    Answer ✓
    Options

    DATE_FORMAT(`DateFIeld`, '%m, %d, %y')

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • josephvargo
    josephvargo Member
    Options

    Great suggestion Godzilla! There are many different posibilities that influence how we could answer this.  Is the date already a string? Where is it showing up in the card?  The formula above is going to change it to a string.

    The below formula will maintain your data type as a date if you need it.  DATE(`DateField`)

  • kshah008
    kshah008 Contributor
    Options

    @Valeriehern, did any of the above replies help you out?

  • Valeriehern
    Valeriehern Member
    Options

    Yes. Sorry didn't loop back around earlier. Thank you!

  • jim_inx
    jim_inx Member
    Options

    %M gives the full Month spelled out (eg, November), apparently with a trailing space for some reason

    %m gives the number of the Month (eg, 11)

    What gives the format that is above ('Nov')? 

     

    Would be nice to have a page of the different format options on date.

  • jim_inx
    jim_inx Member
    Answer ✓
    Options

    Found the answer here --> https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Chart_Properties/Changing_the_Date_Format_in_Your_Chart

     

  • [Deleted User]
    [Deleted User] Member
    Options

    @jim_inx,

     

    Thank you for the additional comment and solution!

     

    Regards,

    Dani

This discussion has been closed.

Categories