OBIEE adding an integer to date

Question

I am looking to add a number of days (column 1- integer) to a date (column 2- date) to create another date in the future (column 3- date).

What is the code required?

Answer 1

Try using this formula for column3

TIMESTAMPADD(SQL_TSI_DAY,CAST("Table"."Column1_int" AS INTEGER), "Table"."Column2_date")