Need Help understand this query

[g0009348]

Hello All,

Please can you help me understand the following query.

Between (DateAdd("d",-DatePart("w",Now())+3,Now()))-28 And DateAdd("d",-DatePart("w",Now())+3,Now())

I have been given an old database to understand but i'm having trouble, understanding what a report is trying to produce.

Many thanks

 

[Kyle123]

Seems like a rather convoluted way of getting the last 4 weeks data

 

[Micron]

There must have been a reason to go to all that trouble...
g009348 - since it's not your db but is probably your business, maybe this will help you to figure out why it was done this way. Assume that it is Tuesday, 09/08 when you run the query with this criteria expression (it's not really a query as you called it).

DatePart("w",Now())+3 This returns the weekday as a number, Sunday based, 3 days from Now().
Tuesday is (3) so it returns day 6 of the week (Friday).

DateAdd("d",- This would add negative 6 days from Now()) - Wednesday 09/02
-28 This moves back 28 days from that Wednesday; 08/05
DateAdd("d",-DatePart("w",Now())+3,Now() Again, adds negative 6 days to Now(), which would be 09/02
So it translates to "Between 08/05/2015 and 09/02/2015" (29 days, I think).

Hope I got it right.