Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try loading like:
Load
Date(DateExcelField, 'DD-MMM-YY') as Date
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';