Date Difference

[steigrafx]

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

[comment]

Try =

Let (

rem = WarrantyExp - Get ( CurrentDate )

;

Case ( rem > 0 ; rem )

)

Alternatively, you could apply conditional formatting to the field.

[steigrafx]

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

Kevin

[steigrafx]

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.

[comment]

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

Especially since this is a rather trivial problem.

[Genx]

Lol Michael,

Cheer up and take it like a man :