Today() Function System Clock???

[#1]

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

[swuehl · Accepted solution]

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

[#3]

Haha, I knew it was me. 

Thanks so much swuehl--I've been working on Rolling Twelve Month Sparklines and was so close.

Thanks!!!