How to get max date from a table

[#1]

Hi,

Tab:

Load

Serial,

Date

from ...

I want to get the max date from this table.

I dnt want to use group by and peek.

Since using peek first I have to sort it and get Max date.I dont want to do this.

Any suggestions.?

[#2]

Hi,

order your table

Tab:

Load Serial, Date from .... order by Date;

Let vDate = Peek('Date', -1, 'Tab'); //*** -1 is the last record in your table

So you didn´t need a "Group by".

Good luck!

Rainer

[#3]

Hi,

I have mentioned that I dnt want to order my table and dnt want to use Peek.

Any Options?

[#4 · Accepted solution]

Hi,

you also can use:

MaxDate:

Load

Max(Date) as MaxDate

Resident Tab;

Now MaxDate is a value in a field. Do you need a variable $(vMaxDate) as example you have to use PEEK!

Rainer

[#5]

Hi

Thanks I used max() And got the required result.......