<div>
Maybe, is that doesn't work let us know.<br />
I will try it on my end also.<br />
<br />

</div>


Maybe, is that doesn't work let us know.
I will try it on my end also.



<div>
the status shows complete , how can that be overdue?
</div>


the status shows complete , how can that be overdue?

<div>
I tried it and it seemed to work. Make sure in your table the status is spelled right and there is no space in front of the first character. If it still doesn't work, check the system clock to make sure Date() is showing today. <br />
<br />
Flyster
</div>


I tried it and it seemed to work. Make sure in your table the status is spelled right and there is no space in front of the first character. If it still doesn't work, check the system clock to make sure Date() is showing today.

Flyster

<div>
<div class="content wysiwyg-content">
Fields in a table:<br />
<br />
Date Requeted<br />
Target Date<br />
Completed date<br />
Status<br />
<br />
Date Requested: 4/15/09<br />
Target Date: 4/15/09<br />
Completed Date: 4/15/09<br />
<br />
Status: Completed<br />
Todays date : 4/28/09<br />
<br />
When I apply the formula below... I get get OVERDUE is that right???????, bit confused<br />
<br />

<pre><code id="code-309901">=IIf([Status]&lt;&gt;&quot;Completed&quot; And Int([Target Date])&lt;Int(Date()),&quot;Overdue&quot;)
</code></pre>
</div>
</div>


Fields in a table:

Date Requeted
Target Date
Completed date
Status

Date Requested: 4/15/09
Target Date: 4/15/09
Completed Date: 4/15/09

Status: Completed
Todays date : 4/28/09

When I apply the formula below... I get get OVERDUE is that right???????, bit confused


Calculate the Overdue date in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.