query to put order dates in date categorises (1 Viewer)

arnelgp

error reading drive A:
Local time
Today, 11:22
Joined
May 7, 2009
Messages
9,350
you are in liberty to adjust the calculation to:

(DateDiff("d", p1, Date()) <= 7)
 

Number11

Member
Local time
Today, 04:22
Joined
Jan 29, 2020
Messages
127
you are in liberty to adjust the calculation to:

(DateDiff("d", p1, Date()) <= 7)
yeah changing it from 8 to 7 does work either it seems that datediff is working on the assumption that the week starts on the sunday as if i enter Sundays date 05.04.2020 it appears in the weekly count. but last week tuesday to today only counts the sunday within the week total?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom