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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 651 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 755 Automate
- 187 Apps
- 480 APIs & Domo Developer
- 71 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 407 Distribute
- 118 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive