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

how to add months 24 to a date field in the OTBI Report Filter

Summary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI


Content (please ensure you mask any confidential information):

Case when current_date<add_months(length of service date,24) then add_months(length of service_date,24)

WHEN current_date>=add_months(length of service date,24) then add_months(add_months(length of service date,floor(datediff(current_date, length of service dt)/365.25*12)),) END

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

24B


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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