Date Object in Qlikview

[#1]

Hi,

I have a column "DATE" with values as JAN 2011, APR 2012, AUG 1999.....etc.

I need to create a date object. Can anyone help me with this ?

[its_anandrjs]

Hi,

Which object you want to create.

Regards

Anand

[#3]

question wrong pls check it once and come back

[ashfaq_haseeb]

Try like this

load *, date(date#(DateField,'MMM YYYY')) as Date ;

load * Inline

[

DateField

JAN 2011

APR 2012

AUG 1999

];

Regards

ASHFAQ

[#5]

Actually, I m preparing a dashboard. In a table I have a Column called

DATE

Jan 1999

Apr 2000

-

-

-

etc.

I need to create a Date Object which displays, Month and year

[vardhancse]

create a date object with date field. u will see as expected

[its_anandrjs]

Create the master calendar for this and create the date field.

Regards

Anand