2 Replies Latest reply: May 19, 2014 3:28 AM by Renuka Sasikumar RSS

    Date Format

    UPALI WIJERATNE

      Hi Friends

       

      1-Oct-88
      30-Sep-86
      1-Sep-01
      3-May-93

      I have above date format in my excel sheet. But when I load data into my QV document I get the following date format

      10/1/1988

      9/30/1986

      9/1/2001

      5/3/1993

       

      But I want the date to appear as per excel sheet. Eg 1-OCT-88  pls help me to write script when I load the data to get the desired date format