Another Weekdays Question

Oct 26, 2006

I have a database (big surprise :rolleyes: ) and I need it to calculate and filter information based on a process name, a number of days for that process and a schedule date.

For the process NC Batch I need it to calculate out 15 working days from today excluding weekends and holidays and then find the records in the orders table that has a schedule date less than or equal to the returned date. I have a calendar in excel that does it with a look up.

I have a table listing holiday dates and a table listing processes and the corresponding day count.

In the query I currently have it listed as

[ScheduleDate]<=Date()+20.

but this will not take into account holidays and it includes weekends.

I know there are several threads on work day functions but I could not get any of them to adapt to my needs. Sorry.

View Replies


ADVERTISEMENT

Weekdays...

Jan 3, 2006

Hello everyone..

First of all...I am really thankfull for this Forum.

I have a Question

I have 2 dates. FromDate and ToDate

I want to Calculate the days without the weekdays.

Please help..

Thank you very much in advance...

View 4 Replies View Related

Weekdays Exclusion

Jul 3, 2006

I m new 2 access, i have a query which i simply do not know how to handle. Please if anyone can help me:

I have a form having two dates on it, First is Invoice Date and the second is delivery date. What i wish to see is that automatically the invoice date takes date from system (this part is done), and the delivery date field automatically adds 2 more days to it and excludes weekend days, saturday and sunday. for example: a date of 6 July 2006 was picked by invoice date field from system, the delivery date now should add 2 more days to it plus it must not include weekend days in it, so the resulting date in delivery date field must read 10-Jul-2006.

Regards,

Darno

View 5 Replies View Related

Weekdays In Middleeast...

Jul 4, 2006

Hi,

I live and work in middle east. Here the weekend starts on Thursday and the week starts on Saturday. Thursday and friday are Off Days. Saturday is the first day of the week. I have a problem related to date calculations.

I have a form having two date fields on it.

1) INVOICE DATE
2) DELIVERY DATE

i wish to see that the INVOICE DATE automatically takes system date from system and same applies for DELIVERY DATE but the only difference will be that the DELIVERY DATE field automatically adds next two more days from the system date. If either of the next two days that are added to system date is/are weekend (thursday or Friday) then it must show the first available working day after the weekend.

for example: a date of 5 July 2006 was picked by INVOICE DATE field from system, the DELIVERY DATE field now should add 2 more working days to system date (it must not include weekend days in it), so the resulting date in delivery date field must read 09-Jul-2006.

I am sure that there are people who can solve my query


Regards,

Darno

View 2 Replies View Related

Adding 3 Weekdays To Date

Aug 24, 2005

I'm an Access novice! I have a table with a library loan date field defaulting with today's date and a due back field. I want the due back field to show a date 3 weekdays after the loan date. I've tried using DateAdd("w",3,Date()) but this just adds 3 days, not weekdays. Does anyone know how do I get it to skip weekends? If I need to use VBA, please supply instructions for including the code, as well as the code itself. :confused:

View 6 Replies View Related

Calculate No. Weekdays Between Dates

Mar 25, 2008

:confused: DateDiff gives me the number of days between 2 dates but how do I count only WORKING days between 2 dates?

I hope someone can help?

Cheers

View 1 Replies View Related

Query Parameter To Just Return Weekdays

Oct 11, 2007

I am trying to write a query that looks at groups of records for averages and maximums but the records are only from Mon-Fri (Trading Days). I have a query that runs everyday and compares today's close to see if it is greater than the maximum close of the last 20 trading days. I want to use between date()-21 and date()-1. BUT this will include weekends where there is no data.

QUESTION: Is there a way to say between the last 20 trading days(Mon-Fri)?

I researched dateadd() and found one place were it says that "w" is used for weekday. http://www.database-design-2000.com/dateadd.htm BUT when I did a simple query to see if it would exlude the weekends it doesn't. I will have no data for the weekends but if I am doing an average of the last three days and this is run on Monday, it will only include Monday and not the previous Thursday and Friday. Thanks for your help:)

View 2 Replies View Related

Modules & VBA :: Executing Function Between Business Hours On Weekdays

Sep 13, 2013

What I am trying to do is execute a function M-F every 2 hours between 4am and 6pm. The 2 hour part was easy, I just created a form with a timer, but the other part isn't working so well, here is my latest attempt.

Code:
StrTime = Time()
If Not ((Weekday(Now()) = vbSaturday) Or (Weekday(Now()) = vbSunday)) And (StrTime > "4:00" Or StrTime < "18:00") Then

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved