How do I make criteria = dates

[Ian]

I want to do a query, part of this query I need to know if a date is
approaching

i.e if john has completed training on the 20/03/06 and this training expries
on the 20/3/08. When I ran my training query I need to know any dates that
are 60 and 30 days from the expiry date.

I hope there is someone where that can help me out

Ian

 

[Allen Browne]

In query design view, type an expression like this into the Field row:
Due: DateDiff("d", Date(), [ExpiryDate])

In the Criteria under this, you can use:
<= 30
or perhaps:
Between 0 And 60

 

[Ian]

Hi Allen

Thanks for the infomation that is working great

Ian

In query design view, type an expression like this into the Field row:
Due: DateDiff("d", Date(), [ExpiryDate])

In the Criteria under this, you can use:
<= 30
or perhaps:
Between 0 And 60

I want to do a query, part of this query I need to know if a date is
approaching

i.e if john has completed training on the 20/03/06 and this training
expries
on the 20/3/08. When I ran my training query I need to know any dates
that
are 60 and 30 days from the expiry date.

I hope there is someone where that can help me out

Ian