Query criteria - Looking for 5 weeks from this week

[GDC1970]

I need the criteria to pull all dates for five weeks from this week.

I am using the following for query criteria and it works, but now that the year is ending, it does not work.

Year([Activity Date])*53+DatePart("ww",[Activity Date])= Year(Date())*53+DatePart("ww",Date())+5

[MikeTheBike]

Hi

I do not understand why you are multiplying by 53, but I suspect the criteria fails when the [Activity Date] changes to January next year because the Date part changes from 52/53 in the previous week to 1 and is therefore less than DatePart (week) of to-day.

Without knowing what you are trying to do or anything about your data, would this criteria be of any use

[Activity Date] = DateAdd("ww", 5, Date())

??


MTD

[GDC1970]

Thank you for your assistance.
That works but it only gives me all my activity dates on Friday 5 weeks out. I need it to show me all dates Monday through Friday 5 weeks out.

[Rabbit]

Use less than or equal to instead of equal to.

[GDC1970]

It does not go into next year since the weeks start over. 1-52

[Rabbit]

I know, that's why Mike suggested using DateAdd. And if you wanted stuff in between, that's why I suggested using less than or equal to in addition to his DateAdd.