date range question

I have a field called 'hire date formatted' as such:
DATE_FORMAT(CONVERT_TZ(`hireDate`, 'America/Denver', 'UTC'),'%m/%d/%y')
I have to do this as 'hiredate' has the wrong time zone for its records, but I cannot choose 'hire date formatted' as one of the selections even though its marked share calculation on dataset
Any help would be appreciated
thanks
Best Answer
-
Have you tried doing the date conversion in a dataflow? Then the output dataset would just contain the "hireDate" column with the correct info, no need for an additional beastmode if you do it that way.
MySQL dataflow could do the trick https://www.w3resource.com/mysql/date-and-time-functions/mysql-convert_tz-function.php
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**2
Answers
-
Have you tried doing the date conversion in a dataflow? Then the output dataset would just contain the "hireDate" column with the correct info, no need for an additional beastmode if you do it that way.
MySQL dataflow could do the trick https://www.w3resource.com/mysql/date-and-time-functions/mysql-convert_tz-function.php
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**2 -
looks like that worked...thanks
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive