My head isn't working well today. I've tryingto modify a current calcualtion to show me the time remaining of a 3 year EOL (end of life) on a computer. right now i have it just displaying a word Retire or Serviceable depending on what side of 3 years it falls on. here is the current calc.

Case (

Get ( CurrentDate ) ≥ Date ( Month (Date Purchased); Day (Date Purchased); Year (Date Purchased) + 3) ;

TextColor ( "Retire" ; RGB ( 55 ; 0 ; 0 ) ) ;

Get ( CurrentDate ) ≤ Date ( Month (Date Purchased); Day (Date Purchased); Year (Date Purchased) + 3) ;

TextColor ( "Serviceable" ; RGB ( 0 ; 153 ; 0 ) ) ;

" " )

i want to replace the "Serviceable" with the # of days left to 3 years from date purchased.

thanks in advance.

Use the following in place of "Serviceable":

Date(Month(Date Purchased); Day(Date Purchased); Year(Date Purchased) + 3) - Get(CurrentDate)

Make sure your calculation is set to be unstored so it updates when the current date changes. The result of the calculation should be number or text.

thank you very much.