Forum Discussion

Mastec's avatar
Qrew Member
2 years ago

Error in workdate formula field that is trying to Move a End Work Date if it falls on a holiday or a weekend.

This work date formula field results in an error (can't refer to the field itself in a formula) How do I get around this?

var date datetoo =ToDate([Start Date])+[Duration]+[Lag Time];

var date datetooadj =If([End date day of week.]=0,$datetoo+Days(1),If([End date day of week.]=1,$datetoo-Days(1)));

var date dateholiday = If([Expected End Date (todate) - Name]<>"",$datetooadj+Days(1));

var workdate nextdate=ToWorkDate($dateholiday);

If(not IsNull([End Date Override]),[End Date Override],$nextdate)

Cloudbase Services
No RepliesBe the first to reply