time remaining

[grumbachr]

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.

[John Mark Osborne]

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.

[grumbachr]

thank you very much.