Hide records that are past current date

G

Guest

I have a form that shows a StartDate and an EndDate. I need to hide records
that are seven days past the NOW() date. How do I do that?
Thanks
 
T

tina

base your form on a query. add criteria to the StartDate or EndDate field
(whichever you want to base the selection on), as

=>Date()-7

be careful when using Now(), because that is very specific to "this minute
and this second", rather than just "this date". if your date/time fields are
populated with date and specific time values, then getting all the records
for specific *date* ranges (irregardless of time) takes a little more work -
so i won't go into that unless you need it.

hth
 
G

Guest

Once again, Thanks. Exactly what I need.

tina said:
base your form on a query. add criteria to the StartDate or EndDate field
(whichever you want to base the selection on), as

=>Date()-7

be careful when using Now(), because that is very specific to "this minute
and this second", rather than just "this date". if your date/time fields are
populated with date and specific time values, then getting all the records
for specific *date* ranges (irregardless of time) takes a little more work -
so i won't go into that unless you need it.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top