5 Replies Latest reply: Apr 7, 2016 4:46 AM by jagan mohan rao appala RSS

    converting timestamp to date and then to num

    Shashank Seth

      Hi Geniuses,

       

      I am facing problem while converting timestamp to date

       

      I have the timestap coming as text from source like below

       

       

      4/6/2016 9:52 AM
      4/6/2016 10:28 AM
      4/6/2016 10:32 AM
      4/6/2016 10:40 AM
      4/6/2016 11:35 AM
      4/6/2016 11:38 AM
      4/6/2016 11:41 AM
      4/6/2016 11:42 AM

       

      I want to first convert it into date and then change that date into number

       

      As i have to calculate the open days for the ticket

       

      Thanks in advance

       

      Shashank