| Author |
Topic |
|
lsy
Yak Posting Veteran
57 Posts |
 Posted - 2006-10-17 : 05:08:04
|
| How to convert a date into work week?? do there have any website to recommend?? some it count 3 days it consider a week but some 1 day also consider a week. so do there have any method to differentiate it?? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-17 : 05:14:46
|
It depends on individual organization. What is your organizaiton's definition ?
KH |
 |
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-17 : 05:17:48
|
| so can i have a list all? so that next time when the defination is different i know what method to use!!thanks!! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-17 : 05:26:51
|
| There is a definition for ISO week numbering in BOOKS ONLINE.Peter LarssonHelsingborg, Sweden |
|
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-17 : 05:32:22
|
| how it differenciate in sql statement?? how i query the date as work week?? i know there got a syntax is format(date, 'ww',1,2) this will return as 3 days as a week...but i not really remember what the 1 and 2 meaning... anyone can help? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-17 : 05:35:11
|
| Which tool are you using?Peter LarssonHelsingborg, Sweden |
|
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-17 : 05:37:09
|
| MS Access |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-17 : 05:38:33
|
| What does the help file tell you?Peter LarssonHelsingborg, Sweden |
|
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-17 : 05:55:46
|
| this syntax is previous i get from a website... but now i can't find it... if now if i want 1 day also consider a week... how should i write it?? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-17 : 06:15:26
|
| Press F1 key.Peter LarssonHelsingborg, Sweden |
|
|
|
lsy
Yak Posting Veteran
57 Posts |
Posted - 2006-10-17 : 23:44:02
|
| In help file it just provide 1 function only... which is FORMAT(mydate, "ww") it return although one day also consider a week...Example: 1/1/2005 some calender consider ww52 on 2004 some consider ww01 on 2004For that function it will return ww52 for 1/1/2005so any idea for the other result?? |
|
|
|
|
Work week format