Hi,
I am dealing with schedules which vary based on a four week rolling programme. I neeed to display which week we are currently on from current date - and calulate what week exisitng data was collected based on a date.
I have used DATEPART to show the week number from the first full week in Jan 06 but I can't work out a simple formula to convert the week number into 1,2,3 or 4.
For example week commencing 20th Feb is the 8th week - but as part of our rolling cycle it is week 4.
Any help gratefully recieved - thanks!
I am dealing with schedules which vary based on a four week rolling programme. I neeed to display which week we are currently on from current date - and calulate what week exisitng data was collected based on a date.
I have used DATEPART to show the week number from the first full week in Jan 06 but I can't work out a simple formula to convert the week number into 1,2,3 or 4.
For example week commencing 20th Feb is the 8th week - but as part of our rolling cycle it is week 4.
Any help gratefully recieved - thanks!