2 Replies Latest reply on Aug 23, 2018 6:38 AM by Elizabeth Perry

    Format dates in Tableau Prep using custom SQL

    Elizabeth Perry

      Hi, I have a time / date field, current format 'dd/mm/yyyy, hh:mm:ss AM/PM', I'm using custom SQL to limit the fields I'm bringing in to union and also to add additional detail via case statements but I can't figure out how to convert the date to just show dd/mm/yyyy, convert(date,[UPDATE_DATE) doesn't work. Any help would be appreciated.