SELECT M.last_name, M.first_name

FROM Members AS M

WHERE M.birth_date BETWEEN CAST(CURRENT_TIMESTAMP AS DATE)

AND DATEADD (DD, 30, CAST(CURRENT_TIMESTAMP AS DATE));

Thank you for cleaning it up, and the CURRENT_TIMESTAMP tip. Also, this query...

I got it thanks. I had the cast statements wrong. I don't know if this is more complicated but I figured it out.

SELECT ...