Hi,
My question is about aggregation in Crystal Report
I want to select from myTable only records which timestamp field is maximum nearly to given date in year, as SQL Expression I suppose it will be :

select max(timestamp), other fields from myTable where (day(timestamp)<=DD and month(timestamp)=XX) or (month(timestamp)
How can I do this selection with Crystal Report, Is it possible at all???

Regards, Sevdalina

Best regards

Sevdalina Draganova