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
So the report is filtered to "current user"... unsure how what you're asking would work.

------------------------------
Thanks,
Chris Newsome
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
change it to an Any of the following

when 
[Assigned to] = current user
[holiday] is checked.


ie make a new checkbox field called [Holiday?] and then enter in all the holidays as Activity record for at least the next year.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------