Hide records that are past current date

[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

 

[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

 

[Guest]

Once again, Thanks. Exactly what I need.

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

 

[tina]

you're welcome

Once again, Thanks. Exactly what I need.