SQL for Hire Date + 30 days — 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 for Hire Date + 30 days

edited Apr 1, 2020 1:55PM in Reporting and Analytics for HCM 2 comments

Summary

does anyone have a quick SQL for finding employees hitting their 30 day mark after hire?

Content

Hi folks - hoping this is an easy one! Does anyone have a quick and easy SQL for OBI: need to identify employees hitting their 30, 60, and 90 day make of tenure with the company. Is this is easy as:

Enterprise Hire Date = CURRENT_DATE-30? This doesn't seem to work in BI. Is there a better SQL criteria to identify these folks?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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