Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

upaliwije
Contributor II

Date Format

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

2 Replies
MVP
MVP

Re: Date Format

Try loading like:

Load

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

renuka_sasikumar
Contributor III

Re: Date Format

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