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

    Date formatting

      Hi,

       

      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

       

      Thanks,

      asolsson