Forum Discussion

JohnThomas's avatar
JohnThomas
Qrew Cadet
8 years ago

Removing Holidays and Weekends between two dates and calculating days

Each year i will have number of hoildays , so i need to add in a table as records so from there i need to fetch the holiday dates and calculate in another table where the two date fields are there. Is...
Formulas and functions
ChrisNewsome's avatar
ChrisNewsome
Qrew Captain
5 years ago
I'm trying to get Holidays to show up in a calendar report, do you know of a way to get these variables to affect that? For instance, we have a table called "activities" that each user looks at a calendar report  from to know what they're doing day to day. I'd like to have a way to show holidays so they don't mistakenly schedule things on a day off.

------------------------------
Thanks,
Chris Newsome
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Are you looking for a way to have an entry for each Employee for each holiday?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • ChrisNewsome's avatar
    ChrisNewsome
    Qrew Captain
    5 years ago
    Hey Mark. Ideally, I'd rather just block the day off for everyone.

    ------------------------------
    Thanks,
    Chris Newsome
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Why not just manually enter the holidays and adjust the report filters so that holidays are seen by all users.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • ChrisNewsome's avatar
        ChrisNewsome
        Qrew Captain
        5 years ago
        Enter them how? Create an activity for each employee for each holiday?

        ------------------------------
        Thanks,
        Chris Newsome
        ------------------------------