Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


How do find date difference for only business days?

 
Logged in as: Guest
arrSession:exec spGetSession 2,2,36903
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How do find date difference for only business days?
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 How do find date difference for only business days? - 8/10/2006 5:46:18 AM   
  zubinbalsara

 

Posts: 1
Score: 0
Joined: 8/10/2006
Status: offline
Hi members,
I have a field on my page where user can enter a date. I want to compare the user entered date with the current date and  want to find if date difference is greater than 10 business days. How do I find this difference in terms of business days using vbscript? Is there a function that can do that for me?
Thanks everyone for your help
 
 
Post #: 1
 
 RE: How do find date difference for only business days? - 8/10/2006 6:14:19 AM   
  ehvbs

 

Posts: 2012
Score: 48
Joined: 6/22/2005
From: Germany
Status: offline
Hi zubinbalsara,

here is some code to show (off) the DateDiff() function and a way to count
'business days' (== not Sunday or Saturday). It would be more difficult/'expensive'
to check for holidays.


      

Good luck!

(in reply to zubinbalsara)
 
 
Post #: 2
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How do find date difference for only business days? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts