I'm having a brain block guys.
I have the WeekDaysMinusHolidays module and can't remember how to use it in my query:
WorkDays: DateDiff("d",[DueIn],[DueOutNoTime])+1
Can you guys assist?
Regards
WeekDaysMinusHolidays - Datediff
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
WeekDaysMinusHolidays - Datediff
Cheers ...
Dave.
Dave.
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Re: WeekDaysMinusHolidays - Datediff
Solved Guys:
WorkDays: WeekDaysMinusHolidays([DueIn],[DueOutNoTime])
WorkDays: WeekDaysMinusHolidays([DueIn],[DueOutNoTime])
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Re: WeekDaysMinusHolidays - Datediff
Just shows you are improving Hans...
I always struggle to find the answer until I post on the site then it comes to me in a flash... just your presence Hans
I always struggle to find the answer until I post on the site then it comes to me in a flash... just your presence Hans
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: WeekDaysMinusHolidays - Datediff
After posting it just goes "POP".
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.