>Fantastic. That max function works slick. Thanks a bunch.
>
>I changed it, but what is the reasoning for ISBLANK being a bad idea on a date?
You're welcome.
Basically you should use as less functions in Select SQL as possible. ISBLANK is not the same as EMPTY() which you probably had in mind.
In any case, if you have an index on the date, date = {} condition would be Rushmore optimizable while empty(date) would not.
If it's not broken, fix it until it is.
My Blog