Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Write a variable like
Let vToday = Date(Today()+1,'DD/MM/YYYY');
Hope this helps
Thanks & Regards
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)