Changing "week" definition

K

K8

We are being asked to change our reporting from Sunday-Saturday to a
Friday-Thursday span. I have a database that's been built by someone else
that is currently set to pull information by week - by a S-S week. Any
suggestions on how I can change the definition of the "week"?

Thanks!
 
J

John W. Vinson

We are being asked to change our reporting from Sunday-Saturday to a
Friday-Thursday span. I have a database that's been built by someone else
that is currently set to pull information by week - by a S-S week. Any
suggestions on how I can change the definition of the "week"?

Thanks!

Not without knowing how they've set it up, no!

If they're using DatePart() or Format() to extract the week number, open the
VBA editor and use the Help file there to get the definition of these
functions. They have an optional argument specifying the starting date of the
week.

John W. Vinson [MVP]
 
Top