Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm working on a document where I'm using the Today function. Right now the function is returning 12/10/2011??? The date on my machine is 10/12/2011 and the date on the bottom of QlikView(across from where it say For Help, press F1) is saying 10/12/2011. When I open the document from Access Point it is still reading 12/10/2011.
Here is the funtion which is in a text box right now:
=Date(today(1),'DD/MM/YYYY')
Thanks!!!
Confused
Right, your date format specification using DD/MM/YYYY is Day/Month/Year, i.e. 12/10/2011.
Change it to
Date(today(1),'MM/DD/YYYY')
and you should get what you want.
Stefan
Right, your date format specification using DD/MM/YYYY is Day/Month/Year, i.e. 12/10/2011.
Change it to
Date(today(1),'MM/DD/YYYY')
and you should get what you want.
Stefan
Haha, I knew it was me.
Thanks so much swuehl--I've been working on Rolling Twelve Month Sparklines and was so close.
Thanks!!!