getting records from the last 4 weeks 1

[klaas01]

Hi,

Since the new year has started i am dealing with this problem:

to filter records from the last 4 weeks i use this formule:
Format(Date();"yyyyww")-1 Or Format(Date();"yyyyww")-2 Or Format(Date();"yyyyww")-3 Or Format(Date();"yyyyww")-4

the problem is in week 2 of the new year this function won't include record from the last 2 weeks of the previous year.

does anybody knows a solution for this problem?

klaas

 

[PHV]

You may try this formula:
Betwween Format(DateAdd("ww";-4;Date());"yyyyww") And Format(DateAdd("ww";-1;Date());"yyyyww")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

Oops, I meant this:
Format(DateAdd("ww";-1;Date());"yyyyww") Or Format(DateAdd("ww";-2;Date());"yyyyww") Or Format(DateAdd("ww";-3;Date());"yyyyww") Or Format(DateAdd("ww";-4;Date());"yyyyww")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[klaas01]

thats works great! thanks a lot!