Week Query 1

[pd06498]

I've been experimenting with queries to return data on a weekly basis, using datepart and :First Full Week".

I now have results that show data entered on 1st to 4th Jan 04 as week 53, then following on to week 1.

What I was wondering is, what happens when I get to the end of the year and end up with 2 x week 1's and so on. How can I distringuish each week to a year, i.e. in above example, 31 Dec 2003 and 1 Jan 04 both in week 53 of 2003.

Hope I have exlained question clearly enough.

 

[Blorf]

By week, do you mean from Monday to Sunday or what not? If so, then it should not matter if the week starts in one month or year and ends in the next.

If thats the case, I suggest using the weekday function.

somthing like

Week: [mydate]+1-Weekday([mydate])

For week 10/3/04 - 10/9/04 this will return 10/3/04

Basicly returns the Start of the week only regardless of date.

Hope that helps,
ChaZ



"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[pd06498]

Thanks ChaZ

Works like a charm.

Dave

 

[Blorf]

Glad to help.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[fredk]

Just what I needed - thanks!!!

Fred

 

[Blorf]

Ain't Tek-Tips a wonderful place?

Again, glad to help.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/