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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

SQL Query it has to pick start date and end date automatically

edited May 12, 2020 12:39PM in HCM Integrations 6 comments

Summary

SQL Query it has to pick start date and end date automatically

Content

Hi Team,

I have an requirement where start date and end date has to pick automatically.

In sql query i have an parameters start_date and end_date. These parameters has to pick automatically.

For an example, If i run this month(May) start date should be March 20th and End_date should be April 20th.

By using default value in the parameter we can do this but, If use default value in some months we have 30 days. In some months we have 31 days. Date will chage.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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