topic Today() Function System Clock??? in QlikView

Today() Function System Clock???

Wed, 12 Oct 2011 21:34:49 GMT

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

Today() Function System Clock???

swuehl — Wed, 12 Oct 2011 21:37:49 GMT

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

Today() Function System Clock???

Wed, 12 Oct 2011 21:46:57 GMT

Haha, I knew it was me.

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

Thanks!!!