7 Replies Latest reply: Oct 13, 2011 6:19 AM by GJ Strydom RSS

    Date formatting



      I'm having trouble with date formatting,


      I have a table with order dates, and as we all know; date formats are rarely all standardized. I have the following kind of dates:

      • YYYY-MM-DD
      • 39448 (as a number)
      • M/DD/YYY


      and so on..


      Is there any way to script these to make them all the same? I want the output to be YYYY/MM/DD