Hiya
I have a unbound text box that I would like to format a week, so rather than displaying the current week number of the year =Format(Date(),"ww"), I need it to show me what week it is out of a rolling 4 week period.
The form one on which the box will sit is for DLT tapes and we have to insert specific tapes in certain week numbers so the backups work. Currently these are just written down but due to shifts and human intervention (Silly humans)there have been weeks when they are missed.
Not sure if I'd use the above format with some sort of calculation or something, although so far all I get is #Error when trying my calculations anyhow I'm not sure and thats why the question.
Checked the forum and couldn't find anything similar, sorry if I missed something.
Thanks
I have a unbound text box that I would like to format a week, so rather than displaying the current week number of the year =Format(Date(),"ww"), I need it to show me what week it is out of a rolling 4 week period.
The form one on which the box will sit is for DLT tapes and we have to insert specific tapes in certain week numbers so the backups work. Currently these are just written down but due to shifts and human intervention (Silly humans)there have been weeks when they are missed.
Not sure if I'd use the above format with some sort of calculation or something, although so far all I get is #Error when trying my calculations anyhow I'm not sure and thats why the question.
Checked the forum and couldn't find anything similar, sorry if I missed something.
Thanks
