topic Re: date formatting in QlikView

date formatting

master_student — Mon, 03 Oct 2016 11:15:01 GMT

Hello friends

I have a date field that has this format :yyyymm

I would like to change it like that DD/MM/YYYY

any idea?

Thanks a lot

maxgro — Mon, 03 Oct 2016 11:39:59 GMT

date(date#(billing_period, 'YYYYMM'), 'DD/MM/YYYY')

another one

date(MakeDate(left(billing_period,4), Right(billing_period,2)), 'DD/MM/YYYY')

surendraj — Mon, 03 Oct 2016 11:43:09 GMT

In List box--> Properties---> number tab--> Override document settings---> click on Date..(Override your format as u want).

puttemans — Mon, 03 Oct 2016 11:43:30 GMT

Have a look at this document please. It helps me most of the time with these kind of issues 🙂