>You could get the value for Date() prior to your select and use it instead of continually calling the date() function in your sql. A small improvement perhaps but an improvement.

That has made a significant enhancement.

Thanks