Date format

[#1]

I have a field called TIME_ID with dates in the format 20130623.How can I change this to the format jan-13,feb-13,mar-13,apr-13 and so on...

[MayilVahanan]

Hi

Try like this

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MMM-YY')

Edit:

developer_ABHI,

I replied to this Date format. itself.

[#3]

The above format will come up with jan-13 for 30 days in Jan meaning I can see 30 Jan-13's,30 feb-13's and so on.I want just want one jan-13,one feb-13,one mar13 and so on.

[CELAMBARASAN]

Convert it into Text format. Internally it maintains date also meaning it only changes the display value.

Use Text() around the expression.

[CELAMBARASAN]

For more information on datatypes in qliikview click here

[#6]

in the load script?

distinct date(TIME_ID,'MMM-YY') AS Month

[#7]

Thank you everybody for the answer.

[jaimeaguilar]

Put this on script:

date(Date#(TIME_ID,'YYYYMMDD'),'MMM-YY') as Date

First you tell QlikView to recognize the original format of the date (TIME_ID) and then you change it as you wish

regards

[MayilVahanan]

HI developer_ABHI

Please close this post if u get the answer