Calculating Working Weekdays

[Nick Pedder]

Can anyone help me with this please ?

In the context of a recruitment database and the data being job vacancies, I have 2 sets of information - Date Recieved and Origination Date. I am trying to calculate the difference between them in working days.

To do this I am using a query and the expression Expr2: Weekday([DateRecieved])-Weekday([OriginationDate]).
I am using the criteria Between 2 And 6

Unfortunately, the results it brings up make no sense. Some are correct, whilst others are way out.

For example;

Date Recieved Origination Date No of Working days (Expr1)
11/11/03 28/9/03 2
21/11/03 18/11/03 3 (this is correct)
24/10/03 15/10/03 2

I would be very grateful to any one who could point me in the right direction. Thanks

 

[jmonty]

Start with the Access MVPs:

http://www.mvps.org/access/datetime/date0006.htm

hope this helps.

-----Original Message-----
Can anyone help me with this please ?

In the context of a recruitment database and the data

being job vacancies, I have 2 sets of information - Date
Recieved and Origination Date. I am trying to calculate
the difference between them in working days.

To do this I am using a query and the expression Expr2: Weekday([DateRecieved])-Weekday([OriginationDate]).
I am using the criteria Between 2 And 6

Unfortunately, the results it brings up make no sense.

Some are correct, whilst others are way out.

 

[Nick Pedder]

Much appreciated - not something I would have worked out myself !