My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Calculate Working Days With Lead Times, Any Version
|
|
 May 16 2012, 10:28 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 151 From: Bedford England  |
Hi all,
I have some code that will work out the working days from a start and end date, but i want to work out the delivery time on a product if the lead time is say 14 days. so todays date is the 16/5/12 then 14 days would be the 30/5/12, but this only gives me 11 working days how do i get it to add the remaining working days on..? which would give me the 3/6/12. Many thanks in advance! |
 |
 
|
|
May 16 2012, 10:32 AM
Post
#2
|
|
|
Access Wiki and Forums Moderator Posts: 48,645 From: SoCal, USA |
Hi sef,
Check out Brent's fAddWorkdays() function in the Code Archive. Just my 2 cents... (IMG:style_emoticons/default/2cents.gif) |
|
|
|
|
May 16 2012, 11:07 AM
Post
#3
|
|
|
UA Editor + Utterly Certified Posts: 22,726 From: Melton Mowbray,Leicestershire (U.K) |
Hi Sef
What do you class as working days..!! 03/06/2012 (Sunday)..?? (IMG:style_emoticons/default/thumbup.gif) |
|
|
|
|
May 16 2012, 04:20 PM
Post
#4
|
|
|
UtterAccess VIP Posts: 1,855 |
|
|
|
|
|
May 17 2012, 01:34 AM
Post
#5
|
|
|
UtterAccess Addict Posts: 151 From: Bedford England |
Cheers for the replies guys (IMG:style_emoticons/default/thumbup.gif)
Gustav i used the ISO_WorkdayAdd function and it works brilliantly!! Many Thanks Steve |
|
|
|
|
May 17 2012, 03:01 AM
Post
#6
|
|
|
UtterAccess VIP Posts: 1,855 |
You are welcome!
/gustav |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th June 2013 - 01:50 AM |