all records for past 2 weeks

[Annelie]

I know it should be something like now() and?
but I can't get it
Help
Annelie

 

[Guest]

Tr

Between Date() and Date -

Date() give you just the dat
Now() give you date and tim
for this you just want the date

Good luck

 

[Guest]

Opps, I meant 13 for two weeks

Between Date() and Date -13

 

[Tom Ellison]

This may or may not be correct, depending on just what 2 weeks is.
Does it include all of today (so far) plus all the previous 13 days,
or all the previous 14 days? I'm guessing it may be the latter, in
which case you were closer the first time. Then there's the case
where the column for which you have this criterion may have a time
component. Even then it may be correct, but this may depend on the
exact meaning of 2 weeks. Is 2 weeks ago, when it is 10 PM, any time
back 14 days AND 22 hours? If so, there needs to be a further
adaptation.

The possible combinations of the meaning for 2 weeks is complex in
this way, and a thorough definition is worth thinking through before
proceeding. I know it seems intuitively obvious (and it probably is)
but computers are not very intuitive!

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Annelie]

Actually I didn't need such specific data, I just want to minimize the data
displayed without the user having to input a date. I finally figured it out
myself.
Between Now() And Now()-14
Annelie