getting records that are past date

P

patrick

Hi!!!

I've got another problem when it comes to gathering
records witch are, for example, 3 months are more from
today's current date.

Example:
in my table warranty, I want to get: The id,Vendor's name,
and warranty descriptions(warDesc) based on their
expiration field. Where ExpDate..... for example.

How can I write an SQL querry that checks the date
(ie.DateDiff in VBA) and then compares the dateDiff(in
months) to >3(ExpDate).

This querry would only return the records witch are 3
months are more to the current date. The records witch
ExpDate are under 3 months from curentDate, should'nt show
in my report.

Can anyone help..

Patrick...
 

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

Similar Threads

Find oldest warranty ExpDate(s) for each customer 8
datediff 4
Delete records based on multiple criteria 5
Date Brackets as an IIf statement 3
Assigning a value to one cell based on the date in another... And then doing it again 0
not display date in past 2
date query 3
Quarter function based on current date 1

Top