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?
MAX Function on datetime
MAX Function on datetime
Using 8.7 Professional 3025 on MySQL/Windows
Re: MAX Function on datetime
FIND ListwithDates.Entrydate WHERE (ListwithDates.Entrydate<=CURRENT_TIMESTAMP) ORDER BY Entrydate DESC TAKE BEST 1
BO1.DateAttr=ListwithDates.Entrydate
BO1.DateAttr=ListwithDates.Entrydate
Re: MAX Function on datetime
Ah yes, thats the best way. Thanks !!
Using 8.7 Professional 3025 on MySQL/Windows