3 Replies Latest reply on Feb 27, 2015 10:53 PM by SriniVEERAVALLI

    OBIEE column formula help with adding dates in between a range

    ZFMA86

      I have two dates right now in separate columns:  Pay Period Begin and Pay Period End Dates.  I need to create a column formula that gives me the 14 days in between these 2 dates as rows. I can write this formula in one column to get the next day in between the begin and end date:

       

      TIMESTAMPADD(SQL_TSI_DAY, 1, "Field User Tenure"."PP_BD")

       

      I need the formula to then give me the next day, and the next day, and so on through the Pay Period End Date.  How can I write the formula to where it knows to add 1 day to the prior day?