SQL Help for Dates crossing into New Year
I have a requirement to pull a list of dependents that will be turning 21 within 6 weeks (ie. If I run the report today, I should be pulling into those dependents that have a birthday in December/January and will be turning 21.
My query works great until we got to November/December.
I have logic that is looking at the sysdate which I understand that this is my issue I just can't figure out how to add logic to the where clause that says if Current month = 11 or 12 then add a year to sysdate
SQL logic to determine when someone is turning 21