Date Filter help

  • Thread starter Thread starter g
  • Start date Start date
G

g

Hi there,

I trying to filter out records that are more than a week or 7 day.

So my record has a "Date Created" Entry which has the format of
dd/mm/yyyy.

I've tried something like this

DateDiff("d",Now(),[Date Created]) < 8

But it wouldn't work can someone help me in this? Thanks.
 
In the Criteria row of your query, under the date field, enter:
< DateAdd("d", -7, Date())

If you are having difficulties with Access not understanding your dd/mm/yyyy
date format, see:
International Dates in Access
at:
http://allenbrowne.com/ser-36.html
 
Back
Top