max function in case statement

[Former Member]

Hello everyone,

I want to use "max" function in case statement.I want to get latest record depending on two conditions.So,I am using case statement and to get latest date I want to use max function.But,it is not working.Can you please help me with this?

Thanks in advance.

[swaroop_anasane]

Hi Deepali,

It is possible, can you share your query and what server are you running it on?

Regards,

Swaroop