topic Re: Derive Date in QlikView

Derive Date

Mon, 29 Jul 2013 03:25:50 GMT

Hi,

I have field '201305'.

I would like to derive a Reporting Date ( can be start daet of the month) from the above .

How can i get it.

Thanks

Thejo.

tresB — Mon, 29 Jul 2013 04:14:21 GMT

your requirement is not very clear to me. if your '201305' is a date of format yyyymm then you can derive the date like :

date#('201305', 'YYYYMM')

Mon, 29 Jul 2013 04:30:06 GMT

I have a column where i have the month year in the format of YYYYMM Like 201305.

I need to derive the date from this field.

tresB — Mon, 29 Jul 2013 04:33:55 GMT

then try like :

date#( YourDateField, 'YYYYMM')

or even you can use date function to get your desired format out of this like :

Date(date#(YourDateField, 'YYYYMM') , 'DD-MM-YYYY')