adding number of days to date to get a date

[#1]

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

[MarcoWedel]

please post sample data/app

[Gabriel]

Hi riadesai,

I agree with Marco, please post a sample data.

What I was also thinking of is, use preceding LOAD

Table1:

LOAD

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

;

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

FROM $(vRelativePath);

However it will be lovely if you can post sample data.