date conversion

[#1]

hi, im just a beginner in qlikview.. may i know

i got a column list of date - '200901' refers to Jan 09 or '200805' refers to May 09.

How should I convert to 2 columns '2009' and 'Jan' when qlikview reads the column as '200901' ?

Thanks for your help!!

[disqr_rm]

You can use string functions like left(date,4) to take the fist 4 digits and create a new field called year, and so on.

So if you have a script like:

LOAD column1 as ListDate from xxx.xls;

You can create additional fields like:

LOAD column1 as ListDate,

left(column1,4) as Year,

right(column1,2) as Month

from xxx.xls;

You get the idea.

[#3]

thank you!! i got it now.. thanks!!