topic Re: Date format in QlikView

Date format

Fri, 05 Sep 2014 07:39:03 GMT

Hi ,

I have date fields like ''YYYYMMDD''..I want to convert it into MM/DD/YYYY

and I have Fiscal week field like 'YYYYWK' ,I want to convert it into 'WK.YYYY'

How do we correct it.

Thanks

sujeetsingh — Fri, 05 Sep 2014 07:39:54 GMT

Use date function

ecolomer — Fri, 05 Sep 2014 07:40:17 GMT

=makedate(date, 'MM/DD/YYY')

tresB — Fri, 05 Sep 2014 07:46:01 GMT

Date(Date#(DateField, 'YYYYMMDD') , 'MM/DD/YYYY')

Right([Fiscal Week],2)&'.'&Left([Fiscal Week],4) // or, better convert it to date using MakeWeekdate() and then format

MarcoWedel — Fri, 05 Sep 2014 11:11:13 GMT

Hi SwathiRaj P,

Dual(Right([Fiscal Week],2)&'.'&Left([Fiscal Week],4), MakeWeekDate(Left([Fiscal Week],4), Right([Fiscal Week],2)))

Will react like a date field, delivering the numerical value of the weeks start date formatted as you specified.

So using this expression enables you to use this field like any other date field, i.e. without any sorting issues and working date calculations.

hope this helps

regards

Marco