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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:52
Joined
May 7, 2009
Messages
19,169
you are in liberty to adjust the calculation to:

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

Number11

Member
Local time
Today, 17:52
Joined
Jan 29, 2020
Messages
607
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

Top Bottom