2 Replies Latest reply: Apr 3, 2012 7:40 AM by Carter James RSS

    formatting date 1-1-2012 to 1-jan-2012

      Hi Guys,


      I've a simple question (I hope) ,


      How can I convert a date, with the month name in it?


      For example I the following data:


      originaldatecorrectly formatted
      1-1-2012 0:00:0001-jan-2012



      I used the following expression to achieve this:


      date(Date#(date, 'DD-MM-YYYY hh:mm:ss'),'DD') & '-' & Month(date) & '-' & year(date)


      I was just curious whether I could use a simpler expression


      Thanks in advance!