17 Replies Latest reply: Jun 1, 2017 3:22 AM by Rajendra Ongole RSS

    How to strip off timestamp from a date field

    KANCHANA DORAISWAMY

      Hi all,

       

      I have a field in an Excel sheet that has date values stored in this way :

       

      Accepted Date

      September 20, 2016 10:31:55 AM GMT+05:30
      October 14, 2016 8:16:52 PM GMT+05:30
      November 21, 2016 7:05:30 PM GMT+05:30
      November 23, 2016 6:40:42 PM GMT+05:30

       

      However, I need to display the date in the 'mm/dd/yy' format in my chart, without the timestamp. What should I do?

       

      Thanks in advance,

      Kanchana