10 Replies Latest reply: Mar 27, 2015 4:58 PM by Jacob Anderson RSS

    Finicky Dates

      I am pulling date data in from a SQL query and need it to be in MM/DD/YYYY, but it stays in SQL's default YYYY-MM-DD


      I have tried:


      date(DDATE, 'MM/DD/YYYY')

      date(DDATE, 'MM-DD-YYYY')


      date(date#(DDATE, 'YYYY-MM-DD'))

      date(date#(DDATE, 'YYYYMMDD'))

      To add to the craziness is that the line before this I have: date(DDATE)&Market as key, and the result is in MM/DD/YYYY


      Any help would be awesome