Conditional Date

[paperboy22]

Hello,

I am trying to create a variable that results in a yes if the patients birthday is today and a no otherwise. For example, the only the patient's birthday that is today has a birthday of 10/20/1947 and today is 10/20/2018 so I keep getting 'No' for it. I've tried this, but it has not worked: if bdate=today() then Today='Yes';
else if bdate ne today()then Today='No';

[Kurt_Bremser · Accepted solution]

today = ifc(month(today()) = month(bdate) and day(today()) = day(bdate),'yes','no');

[paperboy22]

Thank you that worked great.