I have a question for a report functionality. I have build an object list for vehicles. Each vehicle must be periodically inspected for various points. The dates of inspections are known and are located in the future.

I would like to make a report which shows the upcoming, most recent, inspecting date. I tried to filter the report, but I can only filter one column. I think I have to make a blanc field, and this field must always fetch the oldest date of all the fields with the dates of inspections.

In the report I can filter on this field. But I don't know how to do it. Can anyone please help me?

Yours faitfully,

Erwin Fennema