shaunhubbs
Technical User
Hi all,
I am working with operating room statistics and need to convert a given date to it's position on a 35 day calendar (as operating room blocks are assigned based on this type of calendar for a given period). The 35 day calendar starts on a Sunday in Week 1 (day 1) and goes to Saturday in Week 5 (day 35) for each month (therefore each month does not have all 35 days -- Feb. this year starts on day 4 and goes to day 31).
Example: If I am given a date such as today's (Feb. 27, 2006) I want to know what day it is (I know it's day 30 if I look at my computer's calendar).
Does anyone know how to derive this "day" from a given date?
Thanks to all in advance,
Shaun
I am working with operating room statistics and need to convert a given date to it's position on a 35 day calendar (as operating room blocks are assigned based on this type of calendar for a given period). The 35 day calendar starts on a Sunday in Week 1 (day 1) and goes to Saturday in Week 5 (day 35) for each month (therefore each month does not have all 35 days -- Feb. this year starts on day 4 and goes to day 31).
Example: If I am given a date such as today's (Feb. 27, 2006) I want to know what day it is (I know it's day 30 if I look at my computer's calendar).
Does anyone know how to derive this "day" from a given date?
Thanks to all in advance,
Shaun