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
    ------------------------------