PC Review


Reply
Thread Tools Rate Thread

Adding working days to a timestamp -- please help!

 
 
almurph@altavista.com
Guest
Posts: n/a
 
      23rd Oct 2008
Hi,

I have a trickly little problem that I hope you can help me with. I
need to add *working* days to a DateTime object of the format: yyyy/MM/
dd

For example: say I have a timestamp of the following date:

2008/10/24 <--tomorrow

say I want to add 5 *working* days, not forgetting Monday is a Bank
Holiday

so, the answer should become:

2008/10/24 + 5 = 2008/10/31

that is, Saturday, Sunday and Monday are excluded as Sat/Sun are the
wkeends and Mon is the Bank Holiday


Any way of doing this? Any comments/suggestions/code-samples much
appreciated.

Thanking you,
Colm

 
Reply With Quote
 
 
 
 
Peter Morris
Guest
Posts: n/a
 
      23rd Oct 2008
You need the user to record their holidays. Keep in mind that some companys
close for or more weeks at certain times in the year, some have 2 days for
bank holidays, different countrys have different holidays, etc.



--
Pete
====
http://mrpmorris.blogspot.com
http://www.capableobjects.com

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding timestamp (days/hours/minutes) fields jsg Microsoft Access Form Coding 1 6th Nov 2008 06:06 PM
Adding working days Alou Microsoft Access VBA Modules 4 8th May 2008 04:54 AM
Re: Adding working days Niek Otten Microsoft Excel Programming 2 14th Dec 2006 11:57 PM
Adding only working days =?Utf-8?B?TGVvbg==?= Microsoft Excel Programming 2 18th Oct 2005 08:06 PM
Adding working days George Gee Microsoft Excel New Users 2 4th Apr 2004 11:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:01 AM.