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' AND
RN_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?