thanks tres qv. . .
Since there are multiple dates against each AppNo, for above case your solution will give flag 'Y'. Actually it should be 'N' I think we need to do some group by. but getting some script error. Try from your end and let me know if u find some fruit! Best Regards, Brijesh