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

    How to strip off timestamp from a date field


      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,