topic Re: Date format in QlikView

Date format

Wed, 18 Sep 2013 18:08:37 GMT

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...

Re: Date format

MayilVahanan — Wed, 18 Sep 2013 18:10:43 GMT

Try like this

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

Edit:

developer_ABHI,

I replied to this Date format. itself.

Re: Date format

Wed, 18 Sep 2013 18:26:55 GMT

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.

Re: Date format

CELAMBARASAN — Wed, 18 Sep 2013 18:49:25 GMT

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

Use Text() around the expression.

Re: Date format

CELAMBARASAN — Wed, 18 Sep 2013 18:51:11 GMT

For more information on datatypes in qliikview click here

Re: Date format

Wed, 18 Sep 2013 18:53:10 GMT

in the load script?

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

Re: Date format

Wed, 18 Sep 2013 18:59:25 GMT

Thank you everybody for the answer.

Re: Date format

jaimeaguilar — Wed, 18 Sep 2013 19:08:13 GMT

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

Re: Date format

MayilVahanan — Wed, 18 Sep 2013 19:13:44 GMT

HI developer_ABHI

Please close this post if u get the answer