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

Anniversary Report

edited Jun 16, 2020 7:01PM in Reporting and Analytics for HCM 16 comments

Summary

Anniversary Report

Content

Hi ALL,

Need help in creating a report which populate employee who will complete there 1 year anniversary with company tomorrow. 

ex. Employee Name : John Smith Hire Date : 06/17/2019.

When I run report as of 06/16/2020 I should get John Smith in a report.

How can I use timestampadd(SQL_TSI_year,-1,CURRENT_DATE) function to go to last years previous day. 

Thanks,

Vijay

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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