How to truncate date list box at today's date

[#1]

Hi,

I have a list box in my sheet for date (MM/DD/YYYY). Selecting dates on this box slices the model.

I have the dates there sorted in descending order, and the problem is I see future dates there on top. I have records with dates all the way up to 2016 and that's of no use for me...

How do I get the list box to show dates only up to current day? (that is, not today, April 10th, but the day the sheet is accessed).

Thank you!

Al

[MK_QSL]

You need to check Today() function....

today([timer_mode] )

Returns the current date from the system clock. The timer_mode may have the following values:

0 Date at script run
1 Date at function call
2 Date when the document was opened  

[#3]

how should i check it?

I created a text object with

=today([timer_mode] )

and it shows today's date

[MK_QSL]

Try

Today()

Only..

Load you qvw file by removing all fields except the Date..

[#5]

today() only yields 8/4/14

why is that?

[MK_QSL]

If your file is on server, restart the server...

Or

Close the qlikview apps and reopen the file...

[Roop]

How about scripting your date so that it automatically generates the date up to today:

Let vDateFormat = 'DD-MMM-YYYY';

DateDim:

Load

     Date((today() - RowNo()) + 1, '$vDateFormat') as Date

autogenerate (3000);

[#8]

hmm... I closed and re-opened Qlikview and got this scary message

[Roop]

Always a scary message - sometimes corruption and sometimes you are OK. You just have to hope!

[#10]

does it have anything to do with the new list box with expression I added?

[Roop]

Unlikely