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