Display 0 if negative

[Matt Leach]

I have a calculation field that takes an expiration date and subtracts if from the current system date to display the number of days left between the two

The current calculation is set to:

ExpDate - Get ( CurrentDate )

This is used to display the number of days left until a quote expires.

What i would like to somehow do is set the field so that if the result is a negative number, display it as a 0 instead of the negative number.

Is this possible?

Edited August 4, 2010 by Guest

[David Jondreau]

Max( ExpDate - Get ( CurrentDate ) ; 0)