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}
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,