Remove time stamp from date format

Valeriehern · June 2016

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.

Godzilla · June 2016

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

jim_inx · November 2017

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

Godzilla · June 2016

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

josephvargo · June 2016

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 · June 2016

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

Valeriehern · June 2016

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

jim_inx · November 2017

%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 · November 2017

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] · November 2017

@jim_inx,

Thank you for the additional comment and solution!

Regards,

Dani

Remove time stamp from date format

Best Answers

Answers

Categories