trouble with str_to_date in beastmode
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
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部