Date Format
Hi,
The date in my data set is formatted as YYYY-DD-MM. As shown below:
By default domo assumes the date is YYYY-MM-DD. Therefore all my data is grouped as Jan 2016. Is there a beast mode calculation to reformat the date?
Thanks,
Angel
Best Answer
-
Can you change the format on the input side to conform to Domo's format? That could be the quickest solution. You could try using ETL or Beast Mode extract the date parts and reconstruct them into a new date column. Something like this:
STR_TO_DATE(
CONCAT(
YEAR(`Date`) , '-'
,DAY(`Date`) , '-'
,MONTH(`Date`)
)
,'%Y-%m-%d'
)Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"3
Answers
-
Hi all, Can anybody help @angelsinha out? Thanks!
0 -
Can you change the format on the input side to conform to Domo's format? That could be the quickest solution. You could try using ETL or Beast Mode extract the date parts and reconstruct them into a new date column. Something like this:
STR_TO_DATE(
CONCAT(
YEAR(`Date`) , '-'
,DAY(`Date`) , '-'
,MONTH(`Date`)
)
,'%Y-%m-%d'
)Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"3 -
Hi Aaron,
Thanks for your help. It worked!
Cheers!
Angel
1 -
Just so people are aware. There looks to be a small syntax error here. The solution reads:
STR_TO_DATE(
CONCAT(
YEAR(`Date`) , '-'
,DAY(`Date`) , '-'
,MONTH(`Date`)
)
,'%Y-%m-%d'
)It should read:
STR_TO_DATE(
CONCAT(
YEAR(`Date`) , '-'
,DAY(`Date`) , '-'
,MONTH(`Date`)
)
,'%Y-%d-%m'
)0 -
You can simply do DATE_FORMAT(`Date`,'%m/%d/%y'), will save you concat.
3 -
I do have the same issue
The format of the Date column is "4/1/22" and if I want to use it as my key connector I should change it to Apr 1, 2022
None of the above solution worked. Can you help me find a good formula to put on the formula tile in ETL?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive