days between dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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?
 
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
 
Back
Top