In a particular report I am attempting to isolate the Max date of a field that is less than a parameter entered date. So for example, the user enters in "20151101", I want to isolate the first highest(max) date that is less than November 1 for that particular field.

I've seen some posts that are close to this request, I'm struggling with thinking of a method to do this without bringing all dates that are less than the parameter date.

This message has been edited. Last edited by: <Emily McAllister>,

BY HIGHEST 1 YOUR_DATE_COLUMN
WHERE YOUR_DATE_COLUMN LT YOUR_&VARIABLE

Thanks Tom.