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

    Finicky Dates

    Jacob Anderson

      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)

      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