Access Ver 2.0 Adding days to a date to give target date excluding weekends?

  • Thread starter Thread starter michael.nilsen
  • Start date Start date
M

michael.nilsen

Hi Everyone,

Not sure if i'm posting in the right spot so sorry if its not, please
direct me to the correct location :)

I have three fields in a form, [quote accepted], [days to results] and
[target date]. I need to calculate the target date by adding the [quote
accepted] and [days to results] together but i want to exclude the
weekends as [days to results] is only working days.

Example

Quote accepted date: 16/11/2006

Days to result: 20

Target Date: 14/12/2006

Also there can be time where the information will be missing so
therefore it will have to handle null values ect

I have no preference over code or macro, which ever is better for this
application.
 
Dear Michael:

Since this is a board for posting Macro Help, this isn't the place the
place the request but I would be more than happy to help you.

I need you to answer some simple questions first and then I can help in
writing the function that you're going to need to be able to do what it
is that you request.

1. Do you only want the function to return only Weekday and not
weekends, or would you like it to have the ability to know special
holidays and days when the office will be closed for business?

Let me know and then I can suggest some options for you depending on how
much interaction you're wanting with the function.

Thanks,

Joe P.


-----Original Message-----
From: (e-mail address removed) [mailto:[email protected]]
Posted At: Thursday, November 16, 2006 2:43 AM
Posted To: microsoft.public.access.macros
Conversation: Access Ver 2.0 Adding days to a date to give target date
excluding weekends?
Subject: Access Ver 2.0 Adding days to a date to give target date
excluding weekends?

Hi Everyone,

Not sure if i'm posting in the right spot so sorry if its not, please
direct me to the correct location :)

I have three fields in a form, [quote accepted], [days to results] and
[target date]. I need to calculate the target date by adding the [quote
accepted] and [days to results] together but i want to exclude the
weekends as [days to results] is only working days.

Example

Quote accepted date: 16/11/2006

Days to result: 20

Target Date: 14/12/2006

Also there can be time where the information will be missing so
therefore it will have to handle null values ect

I have no preference over code or macro, which ever is better for this
application.
 
Back
Top