Something like this?
WITH CTE
AS
(
SELECT Date
FROM
Table1
UNION ALL
SELECT date
FROM
Table2
)
SELECT MAX(Date)
FROM
CTE
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe