Recent posts:
Recent replies:

Hi Everyone -

Apologies for the late response on this but for our needs we have decided to go with Jill's recommendation (see below). It is the most efficient and logical option for us with how my entire 50 line query is structured.

AND (DATEPART('YY',CURRENT_DATE) - DATEPART('YY',Patient.BirthDate)) >= 13



Hi Jill -

I plan on trying all the answers out today. Performance will be important for this report/extract so I will be sure to update the post on which approach I take. Thank you for your answer!


Hi Vitaliy -

Thank you very much for pointing this out as I didn't think about that!


Roger has no followers yet.
Roger has not followed anybody yet.
Global Masters badges:
Roger has no Global Masters badges yet.