yes seems like... I hate bad designs, would need to live with it this time... UDF is not permitted in my org... so CASE seems the only option.

Thanks everybody !

Variable in views are out of question... I have a limitation that I have to do it in view only... this is what is happening, that subqueries are impacting the...

see if the below makes some sense, I need help in the THEN part below.

[A] = ( Select A =

Case

-- I am in a view and for a given...

Thanks for this Preetha !

But my logic for getting the dates is complex and involves big queries and writing the same thing twice for min dates will make it difficult.

I...