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:
0