WeekDaysMinusHolidays - Datediff

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

WeekDaysMinusHolidays - Datediff

Post by D Willett »

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
Cheers ...

Dave.

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: WeekDaysMinusHolidays - Datediff

Post by D Willett »

Solved Guys:

WorkDays: WeekDaysMinusHolidays([DueIn],[DueOutNoTime])
Cheers ...

Dave.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: WeekDaysMinusHolidays - Datediff

Post by HansV »

I didn't have to do anything... :joy:
Best wishes,
Hans

D Willett
SilverLounger
Posts: 1728
Joined: 25 Jan 2010, 08:34
Location: Stoke on Trent - Staffordshire - England

Re: WeekDaysMinusHolidays - Datediff

Post by D Willett »

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 :rofl:
Cheers ...

Dave.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: WeekDaysMinusHolidays - Datediff

Post by HansV »

It's called the Power of Posting...
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: WeekDaysMinusHolidays - Datediff

Post by Rudi »

    
After posting it just goes "POP".
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.