0 Replies Latest reply: Sep 28, 2015 9:10 AM by Robert Fishel RSS

    Adding days to an existing date and formatting

    Robert Fishel

      Hello my Qlik friends around the world.  I am trying to re-write an existing Excel formula to use in a Load statement in QlikView.  Here is the Excel formula:

       

      =IF(F2="85DAYPEND",D2+85,

      IF(F2="FINATMPT",D2+30, IF(F2="ATMPTPLUS",D2+30,

      IF(F2="NEEDATPYPL",D2+30,

      IF(OR(F2="ATTEMPT1",F2="NEEDATPT2"),D2+300,

      IF(OR(F2="ATTEMPT2",F2="NEEDATPT3"),D2+270,

      IF(OR(F2="ATTEMPT3",F2="NEEDATPT4"),D2+240,

      IF(OR(F2="ATTEMPT4",F2="NEEDATPT5"),D2+210,

      IF(OR(F2="ATTEMPT5",F2="NEEDATPT6"),D2+180,

      IF(OR(F2="ATTEMPT6",F2="NEEDATPT7"),D2+150,

      IF(OR(F2="ATTEMPT7",F2="NEEDATPT8"),D2+120,

      IF(OR(F2="ATTEMPT8",F2="NEEDATPT9"),D2+90,

      IF(F2="ATTEMPT9",D2+60,"")))))))))))))

       

      I am having trouble with the "D2" portion of the formula.  The "D2" value is a cell with a date value in it, formatted as yyyy-mm-dd.  I need to add, for example 85 days to the existing date if the value in cell F2 is equal to "85DAYPEND".  I would truly appreciate some help with this formula.  Thank you everyone