QlikView Dates

[kangaroomac]

Good Day,

I am trying to get a maximum date in a variable. I have created a date, using date# and makedate in the script. The date displays correctly in a listbox.

When using a text box I use the following expression: =Date(Max(Floor(myDate)), 'DD/MM/YYYY') - It Displays correct.

When I use the same expression when creating a variable though, I get 0.00002485....

Does anyone please have any Ideas why?

[Anonymous]

Could it be that your variable actually evaluates the date mathematically..

27/11/2012 could potentially be 27, divided by 11, divided by 2012.

I think it has something to do with how you've defined or are calling your variable.

[#3]

this code ll load the max date value in script variable

date1:

LOAD date(date#(ChangeDateID,'YYYYMMDD'),'DD/MM/YYYY') as ChangeDateID,

     ChangeDateID as de,

     (MonthID) as MonthID ,

     date(date#(StockDateID,'YYYYMMDD'),'DD/MM/YYYY') as StockDateID

FROM

(ooxml, embedded labels, table is TB02_20120823_120900);

table:

LOAD max(ChangeDateID) as maxdate,

     RowNo() as r

     Resident date1;

let vardate=date(Peek('maxdate',0,'table'));

drop Table table;

[kangaroomac]

Thank you everyone for your reply. I have tried all the above, but unfortunately to no avail. I have uploaded a "quick and dirty" example of what I mean.

The day devided by month sounds logical - but does not calculate to the same number when I manually devide them with a calculator.

Using the peek function to get the max gives me a differnt (8.25.... outcome) instead of the desired date.

[Anonymous]

My calculator gets the divided value I mentioned before.

Solution is to quote the variable when referencing it. Change your text object to this:

='vMaxDate:' & chr(10) & '$(vMaxDate)'