7 Replies Latest reply on Jul 3, 2013 10:14 AM by Ramanujam Nathamuni

    datetime format 07-NOV-12 04.00.01.386 PM

    Ramanujam Nathamuni

      Hi,

       

      we have datetime format as "07-NOV-12 04.00.01.386 PM" I am using below calculated field to get only  DD-MMM-YY using left function on string but I am getting all the value as "NULL". Please let me know what I am doing wrong.

       

      DATE(
      LEFT([date_time] ,9)
      )

       

      date_time="07-NOV-12 04.00.01.386 PM"

       

      Thanks,

      Ram