Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting between days to make 0 days to 1 day

Status
Not open for further replies.

WPCMS

Technical User
Jun 28, 2007
29
US
I am trying to count how many days it takes to close a note from our users. I did the simple

{@CHARACTER TO CLOSE DATE}-{@CHARACTER TO ENTRY DATE}

formula. It shows a note that was created and closed the same day as "0" days. For our averages I need to have it show "1" if it is opened and closed on the same day.

What would the formula be for that?

Thanks,
 
{@CHARACTER TO CLOSE DATE}-{@CHARACTER TO ENTRY DATE}+1

-LB
 
Simple enough!

Thank you,

WPCMS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top