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
- 10.5K All Categories
- 7 Connect
- 917 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 190 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive