Skip to main content
Question

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

  • April 17, 2023
  • 0 replies
  • 35 views

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
------------------------------
This topic has been closed for replies.