MAX Function on datetime

robleer

Hi,
I have a BO with a TimeStamp attribute. Now I want to find the maximum date

Example:

BO1.DateAttr= MAX ListwithDates.Entrydate WHERE ListwithDates.Entrydate <=CURRENT_TIMESTAMP

This does not work and it seems that the MAX function is not working on timestamp attributes? Is there another way to find the latest date of a BO?

joben

FIND ListwithDates.Entrydate WHERE (ListwithDates.Entrydate<=CURRENT_TIMESTAMP) ORDER BY Entrydate DESC TAKE BEST 1
BO1.DateAttr=ListwithDates.Entrydate

robleer

Ah yes, thats the best way. Thanks !!