How to get the week number of a specified date?

[jefrey]

Good day!

Can someone teach me how to get the week number of a specified date?

For example:
01/01/2008 to 01/05/2008 should be week #1
01/06/2008 to 01/12/2008 should be week #2
01/13/2008 to 01/19/2008 should be week #3
01/20/2008 to 01/26/2008 should be week #4
01/27/2008 to 02/02/2008 should be week #5
02/03/2008 to 02/09/2008 should be week #6
02/10/2008 to 02/16/2008 should be week #7
and so on...

Each week starts with Sunday and ends on Saturday.

I have searched the business functions but all i get is the "GetDayofWeek" (B4201480) which doesn't solve my problem.

 

[VickiHedrick]

Check the thread 'ER/BSFN to Work out week of the year'

 

[Zoltan_Gyimesi]

Hi Jefrey,

Welcome aboard of JDEList!

[ QUOTE ]
I have searched the business functions but all i get is the "GetDayofWeek" (B4201480) which doesn't solve my problem.

[/ QUOTE ]

...and have you searched JDEList too, at least 17 days back?

- open JDEList seach panel
- selecet the Developers forum to seach on the left side list
- enter "week" into the Keyword Search Terms field on the upper left side
- mark the "Show a preview of post body with results." check-box
- submit the search pressing the green Submit button on the bottom
- check the previews from top to bottom and you will find the answer soon from WhippingBoy (Darren Ricciardi), posted on 2008. 17th January, - which fit to the pre-view part

Please, let us and WhippingBoy to know, does it help you or not. Thanks.

Regards,

Zoltán

 

[jefrey]

Thanks Guys!

VickiHedrick and Zoltan_Gyimesi for the immediate response.

WhippingBoy's way did the job for me! Thanks to you also.

And for Zoltan_Gyimesi special thanks to you because you taught me how to search more effeciently... I have actually searched this forum before posting but it returned many results and were irrelevant to what i am looking for. But again, thanks for the tips!

 

[Zoltan_Gyimesi]

Hi Jefrey,

Glad to know, that you have found the solution yourself and learned a bit more.

[ QUOTE ]
how to search more effeciently...

[/ QUOTE ]

JDEList is a great source of knowledge, so if you want to search it more efficiently, then please check-out and read the following on the search panel:
- the "(Advanced search tips)" link under the "Keyword Search Terms" label on the top of right pane
- the green Help button on the middle lower part of the panel

These helped me a lot in the past and I am sure it helped many of JDEList member too. You know, generally most search engine has a bit different syntax for complex query..

Two other useful service of JDEList web site, please check the following:
- the little "Remind Me! icon among the "Post Extras" on the bottom of an opened post panel (you can explore the other icons here too)
- the "Favorite Thread! (toggle)" option on the left pane of "Extra information" segment on the bottom of an opened thread view

I do not want to describe these functionalities, let you explore them.
I also encourage you to explore JDEKist features, starting with My Home and the boards under the "Extra information" segment of Main Index view.

Regards,

Zoltán