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?

score 3 · Answer 1 · answered Aug 09 '16 at 04:56

3

Try using this formula for column3

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

answered Aug 09 '16 at 04:56

Dewanta

score 2 · Accepted Answer · answered Aug 15 '16 at 21:44

Thanks for giving me a great start. Here is what ended up working:

TimestampAdd(SQL_TSI_DAY,"Customer"."Cycle Days","Customer"."Next Inspection Date")

"Customer"."Cycle Days" - # (integer) of days to be added to the date "Customer"."Next Inspection Date" - date

2 Answers2