I have a field called "WarrantyExp". I made a calculated field to display the number of days remaining on the warranty using WarrantyExp - Get ( CurrentDate ), but for those fields where the warranty date has expired and is in the past, my calculation results in negative numbers.

What can I add to the calculation so that past warranty dates are ignored?

Thanks,

Kevin

Try =

Let (

rem = WarrantyExp - Get ( CurrentDate )

;

Case ( rem > 0 ; rem )

)

Alternatively, you could apply conditional formatting to the field.

Perfect. I can't thank you enough, Comment.

Kevin

Comment, I've been thinking about this all day. You've been a tremendous help to me, and I want you to know how much I appreciate it.

Kevin.

OK, let's not get mushy... :

Especially since this is a rather trivial problem.

Lol Michael,

Cheer up and take it like a man :