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!

       

      Carter