Date Format
I've got a SQL table where my dates are mm/dd/yyyy as shown in the before picture.
When I create a dataset on this table domo reformats this date to yyyy-mm-dd as shown in the after picture.
My first thought is why is it converting the date to a different format? But more importantly how do I change this so that the data set maintains the mm/dd/yyyy format.
Best Answer
-
i completely agree with you on having the ability to set the default date format. it's something I have to modify in almost every card.
On a card by card basis, you can also use beast mode to convert it to the format you want. You can do something like this:
DATE_FORMAT(`MyDateColumn`, '%m/%d/%Y')
this article covers date formatting in Beast mode http://wiki.domo.com/confluence/pages/viewpage.action?pageId=37460365
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'4
Answers
-
you can change the format back in the chart properties. Go to Category Scale (X) under CHart properties and hover over the Date Output Format field. It will give you examples of how to format. if you want to change it back ot the format you had in your first screenshot, i think typing in the following in the Date Output Format box will do the trick:
M/dd/yyyy
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'2 -
Thanks for the response.
That works for a chart/graph but I'm actually using tables to essentially look at data in a tabular format.
In table settings there seem to be no options to change the format. I would like the default date format to always be mm/dd/yyyy otherwise I need to format the data in ever card I will make from here on out. It would be ideal to do it in one place and never have to account for it going forward ?
0 -
i completely agree with you on having the ability to set the default date format. it's something I have to modify in almost every card.
On a card by card basis, you can also use beast mode to convert it to the format you want. You can do something like this:
DATE_FORMAT(`MyDateColumn`, '%m/%d/%Y')
this article covers date formatting in Beast mode http://wiki.domo.com/confluence/pages/viewpage.action?pageId=37460365
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'4 -
Wow that is crazy you have to make calculated fields for every date you'd like to do this too. Especially if I look at my dataset, the date is formatting properly so Domo had to make an effort to convert my format rather than just use it.
Your workaround works well though, thank you!
1 -
is it possible in date format to change it into a integer format eg: February 2016 is 1/2016 is that only possible in beast mode?0
-
Crazy is an understatment. Simple problem with a complex solution. Fix it Domo!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive