Jump to content

time remaining


This topic is 5642 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5642 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.