Date Format

[upaliwije]

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

[tresesco]

Try loading like:

Load

          Date(DateExcelField, 'DD-MMM-YY') as Date

[renuka_sasikumar]

Hi,

In the Edit Script there is one SET DateFormat='M/D/YYYY'; change this to the date format which u reqd.

For eg: SET DateFormat='DD-MMM-YY';