Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Today() Function System Clock???

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

Tags (3)
1 Solution

Accepted Solutions
swuehl
Not applicable

Today() Function System Clock???

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

2 Replies
swuehl
Not applicable

Today() Function System Clock???

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

Not applicable

Today() Function System Clock???

Haha, I knew it was me. 

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

Thanks!!!