topic Re: Date format. in QlikView

Date format.

Wed, 18 Sep 2013 17:15:58 GMT

I have a field called TIME_ID with date in the format 20130623.How can I change this to the format 06-23-2013 ?

Thanks in advance.

manas_bn — Wed, 18 Sep 2013 17:28:33 GMT

Date(Date#( '20130623', 'YYYYMMDD' ) ,'MM-DD-YYYY')

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

MayilVahanan — Wed, 18 Sep 2013 17:29:48 GMT

Try like this

Date(Date#(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

Date(Date(TIME_ID, 'YYYYMMDD' ) ,'MM-DD-YYYY')

CELAMBARASAN — Wed, 18 Sep 2013 17:33:42 GMT

Hi,

Use Date# function if the field is not in date format.

Date(Date#(TIME_ID, 'YYYYMMDD'), 'MM-DD-YYYY')

if it is already in date format then use

Date(TIME_ID, 'MM-DD-YYYY')

Wed, 18 Sep 2013 17:37:06 GMT

THANK YOU

Wed, 18 Sep 2013 17:37:17 GMT

THANK YOU

Wed, 18 Sep 2013 18:07:04 GMT

ONE MORE QUESTION,

How can I convert this into the format Jan-13,feb-13,mar-13 and so on?

MayilVahanan — Wed, 18 Sep 2013 18:07:56 GMT

Try like this

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