Date Calculation

[djai695]

I want to setup a formula which shows the number of days until the due date, as well as the number of days past a due date.

Not sure how to set this up on my report.

 

[pr2-eugin]

You need to use the DateDiff function to get this information. http://www.techonthenet.com/access/functions/date/datediff.php

The generic code would be.

DateDiff("d", Date(), [dueDate])

The above will result in a positive number if the Due date is in future.

 

[djai695]

Thanks, this worked great. I appreciate the help.

 

[pr2-eugin]

No problemo Good luck