topic Re: Convert a number to a date in QlikView

Convert a number to a date

danialier — Fri, 18 Jul 2014 09:05:47 GMT

Hi,

I have the following formula which should give a date but instead it gives a number...

=if(GetCurrentField("period")='Week',[Publish Date week],[Publish Date month forum topics])

Do you know how to ersolve this ?

thks,dani

MK_QSL — Fri, 18 Jul 2014 09:07:53 GMT

=if(GetCurrentField("period")='Week',Date([Publish Date week]),Date([Publish Date month forum topics]))

jsingh71 — Fri, 18 Jul 2014 09:08:32 GMT

use this:

if(GetCurrentField("period")='Week',Date([Publish Date week],'MM/DD/YYYY'),Date([Publish Date month forum topics].'MM/DD/YYYY'))

sudeepkm — Fri, 18 Jul 2014 09:24:33 GMT

you may probably use the Date format function at the script level to avoid the function being invoked when the chart is rendered.