Bex query If Else flag

Hi,

I have a requirement where I need to check if created date > (today's date-180) then Yes else No. I can write this statement in Bex query designer like below:

(Create date>(today's date-180))*1+0

However I want to display YES if conditions meets else NO. Is there any way to achieve this in query designer formula.

Thanks,

Arvind