Know what day it is??? (1 Viewer)

[mariaw]

Hi

Does anyone know how to create a query, or something....so that the database knows that the 28th August is a Tuesday, (and therefore a working day), that the 25th August is a Saturday (and therefore not a working day), and that 27th August is a bank holiday (so again, not a working day)?

What I need the system to calculate is how many WORKING DAYS fall between 1st August and 14th August (for example)

Thanks!!

 

[mhartman]

Here you go.....
http://www.mvps.org/access/datetime/date0006.htm

Regards
Mark