You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Help for Dates crossing into New Year

Accepted answer


HI All,

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

Content (required):

SQL logic to determine when someone is turning 21

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!