SQL Help for Dates crossing into New Year — Cloud Customer Connect
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

in Reporting and Analytics for HCM 6 comments

Summary:

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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