Forum Discussion

ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago

Calculate a date field with no weekends doesn't work correctly if starting date is on a weekend

OK folks, so I'm tracking shipments that our manufacturing facility ships via our own trucks to another branch. These shipments are always delivered the next business day. Currently, I have a date fie...
Formulas and functions
ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago
I'm getting an error:

A variable declaration must end with a semi-colon.

however, I tried adding one to no effect.

------------------------------
Chris Newsome
------------------------------
ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
6 years ago
Figured it out. I was putting the semi colon  in the wrong spot:

var number DaysToAdd = If(
DayOfWeek([Date Shipped]) = 6,0, // Saturday
DayOfWeek([Date Shipped]) = 0,0, // Sunday
1) // else 1
;
WeekDayAdd([Date Shipped],$DaysToAdd)

Works great now! Thanks again Mark!

------------------------------
Chris Newsome
------------------------------