Date Criteria

[thecheww]

hi guys,
I am newbie just started learning how to use access a month ago. It may be a simple question to some of you guys, but I am having trouble figuring how to implement this.

So I created a query with a field "AuditDate" I want to audit record every 90 days after "AuditDate". I want like a warning to audit my record after 90days. Maybe Click on something on the form to show a list of record. Do anyone have a simple formula i can use to implement the "auditdate + 90 days"?

I also have a query on other database with a field "TermDate". I want to set a criteria to list all my records 90 days or older from TermDate. Please let me know if theres some simple formula

Thank you very much for your help

E

 

[FoFa]

Date() >= Dateadd("d",90,[AuditDate])

 

[thecheww]

Thank you so muchhh

Thank you so much for your help. It worked greattt . this forum is awesome.

E

 

[thecheww]

Date Criteria Question

Hi,
What if I only want to display only the latest date in the Query or Form.
is there a Maximum function. Date()>=DateAdd("d",90,[AuditDate]) AND ((((((Max[AuditDate]????)))))

 

[ejstefl]

You can use:

IN (SELECT Max([AuditDate]) FROM tblAudit)

as the criteria for your AuditDate field in your query.

 

[PuJo]

But what if ?

Ok, I see where you are going, but I tried to use the code on my form, but no go. This is what I have in the form.

Previous PM Date (date field)
Next Due Date (text field)
All I wanted to do was add 90 days to the (previous PM date) and have the new date entered in the (Next Due Date) text field.

Please help.
Thanks in advance,
PuJo