days between dates

J

John

I am using the following- =Int(Now()-[pending due date]) to calculate the
number of days between now and the date in "pending due date" field. I only
want the number of days that are past due to show, but I am getting the
number of days until the date as a negative number.
What can I add to this calculation to make the negative numbers not show up?
 
R

Rick B

=Iif(Now()<[pending due date], Int(Now()-[pending due date]),"")

Rick B

I am using the following- =Int(Now()-[pending due date]) to calculate the
number of days between now and the date in "pending due date" field. I only
want the number of days that are past due to show, but I am getting the
number of days until the date as a negative number.
What can I add to this calculation to make the negative numbers not show up?
 
G

grep

The easiest thing you could do is switch the order. Do =Int([pending due
date] - Now()) The reason you're getting neg nums is because the pending
date is later, and therefore greater, than the current date.

grep
 
Top