J
Joe Cilinceon
I'm trying to figure out how to setup a work week calculation. The week
starts on Saturday and runs thru Friday.
starts on Saturday and runs thru Friday.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mscertified
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
Dorian
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
Dorian
J
Joe Cilinceon
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.
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.
D
Douglas J Steele
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
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
J
Joe Cilinceon
Thanks Douglas exactly what I was looking for.