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
1
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
-
looks like that worked...thanks
1
This discussion has been closed.
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 259 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有