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



Best Answer


This discussion has been closed.