I understand there is problems with it, but I have been unable to find
any solutions on the internet.  Does anyone know how to get around this
limitation?

Thanks in advance...

Jonathan

problem: select Max(date) which is less than actual Max(date) ?
Parameterize table name without constructing dynamic query?
use trigger
Is subquery bad?
Max date in a row