5 Replies Latest reply: Oct 14, 2016 3:48 PM by Rupam Das RSS

    Format

    Priyabrata Das

      Hi ,

       

      I have a time stamp format like : [14/Sep/2016:10:40:00 +0800]

      I tried  the below formula :

      Timestamp(Timestamp#(Left("Timestamp",11)&' '&Right("Timestamp",9),'DD/MMM/YYYY hh:mm:ss'),'DD/MM/YYYY hh:mm:ss') as "User Timestamp"

       

      but  the resultant is coming like : 9/13/2016  10:40:19 AM and i want the output as 13/9/2016 10:40:19 wthout AM/PM.