Add two days for business days

[psaaccess]

Hi all,

On the form there is an input date field, after the update of the input field, the date field has to add days for that input date and give the next date excluding saturday,sunday's and holidays.

example: The input date is 05/26/2009, it will display on the next field 05/28/2009. It added 2 days and excluded saturday and sundays. I used below thread

FAQ705-3213: Calculating a future Workday Date.

But when I enter 07/02/2009 has to add 2 days including with 07/02/09 give out put date is 07/07/09. This excluded July 3rd holiday and saturday and sunday. It is giving 07/06/09 date.
How can I fix this problem?

I appreciate your help.

Thank you,

 

[HarleyQuinn]

Are you using the same table in the example? If you are then it will not be taking into account the 07/03/2009 holiday as it's not in the table and the 07/04/2009 holiday that is in the table is eaten (ignored) by it being on a Saturday.

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[TheAceMan1]

How are ya psaaccess . . .

Also ... the holiday table needs to be updated each year according to the actual business day taken off.

BTW: Whats the point of the two days?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[psaaccess]

TheAceMan1 and Harley,

Thank you your reply

I created the table and addedd the holidays. This is using for hospital. Every year this table need to update manually.
Patient will submit his request and hopital authorities has to reply in 3days.

So It has to add 2 days + patient request date. Totally 3 days.

Thank you,

 

[SkipVought]

Is there a question in there, or was that just you sharing some inside information for no purpose?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[psaaccess]

SkipVought,
I submitted a question not for sharing purpose, Need a solution how to fix it. Please see below information that I submitted on this form.

when I enter 07/02/2009 has to add 2 days including with 07/02/09 give out put date is 07/07/09. This excluded July 3rd holiday and saturday and sunday. It is giving 07/06/09 date instead of 07/07/09.How can I fix it.

 

[SkipVought]

Patient will submit his request and hopital authorities has to reply in 3days.

So It has to add 2 days + patient request date. Totally 3 days.

So where are the "patient request dates" stored?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[psaaccess]

pt request dt is user input field on the form.

 

[psaaccess]

Hi,

Patient request date is input field on the form. I wrote code on patient request date after update event.

Any thoughts?

 

[MichaelRed]

post the actual call. Include the values of the arguments.




MichaelRed