Date Variables

[danielnevitt]

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]

Write a variable like

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

Hope this helps

Thanks & Regards

[MK_QSL]

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)