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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
What field type is the field [Duration]? is it a numeric field type?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
This last line should probably be
WeekdayAdd($start, $k)

But that is not the problem with the syntax.

Are all those holiday fields like  [Holiday - New Years Eve] date field types?  Maybe some are the wrong field type?  or [Start] is not a date field type?