Add value out QV table in textbox

[#1]

Hello all, in my QV application I have a table where I store a date for the most recent data of the different sources, this looks like this

I also store a variable with the the last scriptload date, now i want a text box with the last loaded date en the most recent date (depending on the selected source, always only one selected!)

Now i have the following code;

='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data: '

Now I want a function te get the right value out of the table. I would say the peek functio but that one isn't available in a text box.

Can anyone help me out here, Thnx in advance!

[kaushiknsolanki · Accepted solution]

Hi,

     What you want to show after the Most Recent Data.

     If it is the date. Meaning is a user selects Source and you want to show the corresponding Date, then the statement will be

='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data:' & Date

Regards,

Kaushik Solanki

[#3]

Hi,

You can try Max(Date)

[#4]

Hi,

what you can do is this

Temp_CalendarRange:

Load Max(Datefield) as [vMaxDate]

Resident Table;

LET vMaxDate = Peek('vMaxDate', 0, 'Temp_CalendarRange');

Now use this variable in the text box like this

='Last data load: '&$(vLastScriptLoad)&chr(10)&'Most recent data: '$(VMaxDate)

Hope that helps

sravan

[#5]

Thnx!! Didn't expect it to be that simple!