2 Replies Latest reply: Nov 15, 2014 12:56 PM by Gabriel Oluwaseye RSS

    adding number of days to date to get a date

      I am trying to add date + no of days to get a date.

       

      Whats wrong in below code?

       

      Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME') as DIE_LEAD_TIME,

       

      Date(DIE_DUE_DT + Lookup('LEAD TIME_D','DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE',[DIE_LEADTIME_ITEM_TYPE_REC_TYPE_CODE],'DIE_LEADTIME')) as LEAD_DIE_DUE_DT