15 Replies Latest reply: May 22, 2013 2:08 PM by ROOPA RAMENENI RSS

    Date# Formating conversion issue?

      Im trying to format my date to look like this: ,'DD/MM/YYYY'

      I thought my input mask was correct, but it won't work. Please help

       

      =Date(Date#(ActualStart,'YYYY-MM-DD h:mm:ss TT'),'DD/MM/YYYY')

       

      Raw Input Dates

       

      2012-12-12T17:00:00

          2012-12-14T17:00:00

          2012-12-20T17:00:00

          2012-12-21T17:00:00

          2013-01-02T08:00:00

          2013-01-02T17:00:00

          2013-01-08T17:00:00

          2013-01-18T17:00:00

          2013-01-21T17:00:00

          2013-02-25T17:00:00

          2013-02-27T17:00:00

          2013-03-01T17:00:00

          2013-03-05T08:00:00

          2013-03-05T17:00:00

          2013-03-06T17:00:00

          2013-03-07T17:00:00

          2013-03-11T17:00:00

          2013-03-21T17:00:00