trouble with str_to_date in beastmode

Jbrorby

I'm having complications formating an existing date column to my liking with the beastmode function.

 

The existing date column is currently formatted dd mmm yyyy hh:mm:ss AM or PM.   This is in a table chart, the chart calendar is using the date column I just referenced, and is graphed by none.  Right off the bat, it is weird to me that this date column in the data table (below the chart) displays in the format I just mentioned.  However, in the graph itself, it is displayed as yyy-mm-dd hh:mm:ss.

 

Anyway, I want this column to display as mm/dd/yyyy  (though the backslash, versus a hyphen or colon, is irrelevant) and I want it to be a date column, not a text or abc column.

 

The first thing I tried was Date_Format:   date_format('column','%m,%d,%yyyy').   This results in an abc column and displays mm,dd,yyyy.

 

So I thought I need to string to date it.  STR_TO_DATE((DATE_FORMAT(`column`,'%m,%d,%Y')),'%m,%d,%Y').  This results in a calendar column, but displays dd mmm yyyy instead of mm dd yyyy

 

I thought maybe my double formating command maybe was getting things all messed up so I tried STR_TO_DATE((DATE(`column`)),'%m,%d,%Y').  This just made everything go null.

I even tried a string to date of the concatination of the column broken down month column, day of month column, year column

 

I have done similar things with str to date and date_format and so on in the past with success, though it has been tricky in some cases.  But I'm just not really sure where I'm going wrong on this one

Jarvis

Hi,

 

When I'm working and struggling to format dates this is my go-to document;

 

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/03Date_Format_Specifier_Characters_in_Beast_Mode

 

Let me know if this helps you,

 

Jarvis