Search code examples
obiee

OBIEE adding an integer to date


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?


Solution

  • 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