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 Expression for a specific month and day with a year of current year - 1

edited Mar 5, 2018 5:45PM in Reporting and Analytics for HCM 1 comment

Content

Hi - 

I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year.  I would like to make the year dynamic based on the year of the current date so that the report clause does not have to be adjusted annually for our compensation review cycle.  How do I concatenate a variable year, YEAR(CURRENT_DATE)-1 to a static date '10/01'?    

Any help is greatly appreciated.  Thank you!

Julia

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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