date range question

meadow_ryan

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

guitarhero23

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

meadow_ryan

looks like that worked...thanks