Week Query (1 Viewer)

[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.

Thanks

 

[fernin8r]

have a counting integer that forces a new year after 52 weeks.

dim x as int


loop

if x<52

do the calc for each week here

else

start new year
x=0
end if

x=x+1

end loop