jefrey
Active Member
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.
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.