Re: Removing Holidays and Weekends between two dates and calculating days
Entire Year
Basically i will have a table called "Off" in that table i will have date field "Hoilday Date" , so i will create 14 or 15 records each year . So those records will be my Holidays for the year.
I have another table "Records" , in that table i have two fields "Start" and "End" date fields , so i will select a date in both two fields , for example 15/09/2017 - 20/09/2017 so basically 16 and 17 are weekends and consider 18-09-2017 [Which i added as a record in "Off" table] is a holiday , then i get the number of days as 3 [15 -09-17, 19-09-17 , 20-09-17] .
Is there any native quickbase option.
Many Thanks in advance
Basically i will have a table called "Off" in that table i will have date field "Hoilday Date" , so i will create 14 or 15 records each year . So those records will be my Holidays for the year.
I have another table "Records" , in that table i have two fields "Start" and "End" date fields , so i will select a date in both two fields , for example 15/09/2017 - 20/09/2017 so basically 16 and 17 are weekends and consider 18-09-2017 [Which i added as a record in "Off" table] is a holiday , then i get the number of days as 3 [15 -09-17, 19-09-17 , 20-09-17] .
Is there any native quickbase option.
Many Thanks in advance
