Date Past Function

[Laney]

Is there some type of function I can use in Access to do the following?

One field has dates in it.
When these days are past due I need to know so I can check on the data.

I tried to make another field in my query to calculate this [FIELDNAMEHERE] > Date().

Do I need to create another field that has the current date in it and then make another field to say one is greater than the other or less than the the other or something? I really just need to know when the date entered into this field has passed so I can escalate on the issue.

Any help is greatly appreciated !!



Thanks!
Laney

[narayanis]

You would want to store the date entered (or due date, or whatever it is) as a field in the table, then use the Date() or Now() functions to do a comparison.

[Laney]

Hi there narayanis,
That's what I'm asking is how to do it. hehe

[narayanis]

You will want a field in the table for the date entered (or due date). let's call it table1.dateadded. then you can query like this:

select * from table1 where Date() > table1.dateadded

does that help?

[Laney]

Ok, that helps.. I'll see if I can get it to work. Thanks a bunches!