dateadd conditional formating to equal yes or no

[Todd]

I have a field called next monitor where I have another field called over due.
In the overdue field, I am using the following code to make a yes/no
determination.
overdue: Iff(dateadd("m", [audit_len], [NextMon])<date()"yes","no")
The audit_len is a field that has different numbers for the lenght of an
audit.
I also have a field called Audit_Date. This field is where I put the date
of the last audit, and then the Next_mon calculates when the next audit is
due.
From the nextmon field, I use this data to determine if this audit is
overdue with the code listed above.
The issue is, when I put in a date like 10 Jan 06 in the Audit_Date field,
Nextmon calculates 10 Jan 07. This returns a true statement. Good to go
here.
When I put in a date in the Audit_Date field of anything in 07, and the
NextMon is calculated into 08, prior to todays date, the overdue formula is
returning no, or false.
Not sure what is wrong with the code for this error.
I have used this code on three different Queries for forms, and all the same
issue.

Any ideas on how to make this query run correctly.
This query will be used to provide data to a form and report based on this
field.

Thanks

Todd

 

[Todd]

I just figured it out.
My formula was actually adding the audit length to the date of when it was
due, so it was looking into the future.
When I put the right field for it to properly complete the expression, then
when todays date is past, it will give me the yes.

Thanks

Todd