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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Here is one solution.

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

WeekDayAdd([Date Shipped],$DaysToAdd)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • 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
      ------------------------------
    • EvanMartinez's avatar
      EvanMartinez
      Moderator
      6 years ago
      Hi Chris,

      What does your finished formula look like? Is the closing semi colon on the variable possibly behind the // in the formula Mark suggested and thereby getting ignored by the formula reader and greyed out? if so you may want to try:

      DayOfWeek([Date Shipped]) = 0,0, // Sunday
      1); // else 1

      Nevermind, I see in your response that you got it. 


      ------------------------------
      Evan Martinez
      Community Marketing Manager
      Quick Base
      ------------------------------