Date Transform
I Have a year and a month column in my dataset which are in the format of integers. I want to create a beast mode calculation to concat them and have them as a date field. How can i do that?
Best Answers
-
You can utilize the STR_TO_DATE function and a date format string to convert it to a date.
STR_TO_DATE(CONCAT(`Year`, '-',`Month`), '%Y-%m')
I'm adding in a concat to add the year and month together as a string to then format.
From the documentation:
STR_TO_DATE
Converts strings (that Domo does not recognize as dates) from one or more string columns into datetime values.
You specify the column(s) and the current date format used in those columns.
STR_TO_DATE('DateCol','%m,%d,%Y')**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Hello @domoexpert
Try this
STR_TO_DATE(CONCAT(`YearColumn`,'-',`MonthColumn`,'-01'),'%Y,%m,%d')
(Didn't see Grant's post before answering here :) )
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'0
Answers
-
You can utilize the STR_TO_DATE function and a date format string to convert it to a date.
STR_TO_DATE(CONCAT(`Year`, '-',`Month`), '%Y-%m')
I'm adding in a concat to add the year and month together as a string to then format.
From the documentation:
STR_TO_DATE
Converts strings (that Domo does not recognize as dates) from one or more string columns into datetime values.
You specify the column(s) and the current date format used in those columns.
STR_TO_DATE('DateCol','%m,%d,%Y')**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Hello @domoexpert
Try this
STR_TO_DATE(CONCAT(`YearColumn`,'-',`MonthColumn`,'-01'),'%Y,%m,%d')
(Didn't see Grant's post before answering here :) )
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'0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 572 Beast Mode
- 11 App Studio
- 28 Variables
- 580 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 24 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive