felicia.scott@
New member
- Local time
- Yesterday, 22:05
- Joined
- Jul 20, 2018
- Messages
- 7
Greetings,
I am a novice query builder and seek formula assistance to calculate the difference between two dates while also excluding weekend dates from the calculation.
I found a helpful MasterDates database here that provides the weekend dates to exclude however, I do not know how to integrate it to the formula in the query.
Table 1: Project details has field for date a project was assigned and the date a project was actually started.
Query: Masterdates list of all weekend/holidays hence forth known as non productive days
:banghead:My current formula: [project assigned]-[project started]
ex: project assigned 12/31/2017 - project start 1/3/2018
Result would be 3 but I need it to reflect the actual number of days as 2 since 12/31/17 was a Sunday
Any help in laymen's terms is greatly appreciated. I am not familiar with SQL
I am a novice query builder and seek formula assistance to calculate the difference between two dates while also excluding weekend dates from the calculation.
I found a helpful MasterDates database here that provides the weekend dates to exclude however, I do not know how to integrate it to the formula in the query.
Table 1: Project details has field for date a project was assigned and the date a project was actually started.
Query: Masterdates list of all weekend/holidays hence forth known as non productive days
:banghead:My current formula: [project assigned]-[project started]
ex: project assigned 12/31/2017 - project start 1/3/2018
Result would be 3 but I need it to reflect the actual number of days as 2 since 12/31/17 was a Sunday
Any help in laymen's terms is greatly appreciated. I am not familiar with SQL