Changing "week" definition

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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]
 
Check out the WeekDay , DatePart, Format & DateDiff Functions

HTH

Pieter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change the sort order of days of the week? 2
grouping with a total 1
week numbers 3
Formula to tell day of week 2
Combining Like Tables in a Query 5
Week and days query 8
Week Number 2
Custom date ranges for report groups 1

Back
Top