Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue with adding $(DiffDate) to the expression in load script.
set DiffDateformula = num(DayStart(Date#(left([@9], 8), 'YYYYMMDD'))) - num(DayStart(Date#(left([@5], 8), 'YYYYMMDD')));
let DiffDate = $(DiffDateformula) + 1;
if MonthStart($(timeStampDate)) = MonthStart($(today)) then
whichDay = $(today);
else
whichDay = num(DayStart(MonthEnd($(timeStampDate))));
endif
if (max($(whichDay)- num(DayStart(Date#(left([Due Date], 8), 'YYYYMMDD') - $(DiffDate)))) < 0, 0, max($(whichDay)- num(DayStart(Date#(left([Due Date], 8), 'YYYYMMDD') - $(DiffDate)))))) as [Aging Days]
Regards,