In my SELECT clause I have:MAX(RN_EXECUTION_DATE) AS 'MAXDATE',MAX(RN_EXECUTION_TIME) AS 'MAXTIME',
... and in my WHERE clause I have:RN_EXECUTION_DATE = 'MAXDATE' ANDRN_EXECUTION_TIME = 'MAXTIME'
When executed, I get "Conversion failed when converting date and/or time from character string".I looked at using CONVERT but can't seem to make it work. And, is it the 'MAXDATE' and 'MAXTIME' from the SELECT clause that needs conversion? Or is it something in the WHERE clause?