Your question is rather vague? what are you trying to do?
If you need to know how to figure out the current day of the week, you would
use the DATEPART function, eg.
Dim DOW as variant
DOW = datepart("w",now())
this function returns 1-7, 1=Sunday thru 7=Saturday, so you will have to
make the adjustment for your week which starts on Saturday.
Look in VB HELP for the Datepart function
What I'm asking is how Access sets what a work week is and can it be
changed? I'm not solving a problem but trying to understand how it works.
Really looking for some plain english explanation of these
function/functions. A site that explains it better than the built in Help
would be fine.
There's no concept of "work week" in Access: you have to code your own.
A couple of approaches are illustrated in the Date/Time section of "The
Access Web" http://www.mvps.org/access/ or you can check out my September,
2004 "Access Answers" column in Pinnacle Publication's "Smart Access". You
can download the column (and sample database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
