I have a table with a date field. I need to get a value from the
record with the maximum date--but the date can not be greater then today.

How would I do that?

Thanks,
Edward Dressel