topic Re: Date Variables in QlikView

Date Variables

danielnevitt — Fri, 28 Mar 2014 16:44:21 GMT

Hi,

I have the following date variable:

vToday = Date(Today())

The date is returned in format DD/MM/YYYY

I would like to add vToday+1, however the date keeps being returend as a number ie 41727.

Does anyone know how I specify that the variables should all be in date format DD/MM/YYYY?

Thanks,

Daniel

its_anandrjs — Fri, 28 Mar 2014 16:49:56 GMT

Write a variable like

Let vToday = Date(Today()+1,'DD/MM/YYYY');

Hope this helps

Thanks & Regards

MK_QSL — Fri, 28 Mar 2014 17:12:13 GMT

Date itself is stored as number in QlikView. When you add or subtract any integer from it, it will always return a number.

To keep you date format, you need to use Date Function...

Let vToday = Date(Today()+1,'DD/MM/YYYY');

(same as Anand has suggested)