topic Date Format in QlikView

Date Format

upaliwije — Mon, 19 May 2014 07:21:52 GMT

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

tresB — Mon, 19 May 2014 07:25:36 GMT

Try loading like:

Load

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

renuka_sasikumar — Mon, 19 May 2014 07:28:27 GMT

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';