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

Alert composer: Retrieving data for next 3 months from current date is not working

in Human Capital Management 2 comments


Summary:

Hello we have a requirement to trigger a probation alert 3 months prior before the end date.

We have created a sql query to test the data first before we move to create the filter.

See below screenshot where we used sysdate + 90.

If we run the query today, we're getting data of probation which will end next month which its wrong. We should get data for next 3 months which will records for october only.

Please advice on how to resolve so that we get exact data for the next 3 months.

Thanks



Content (required):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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