Need help with a simple formula, cause I'm a noob.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello, I am trying to get a field to subtract an input date from today's date and if the result is less than 365 days to return the word "Good" and if greater than or equal to 365 to return the actual number of days difference. 

Here is what I have: 

If(Today() - [FS Re-Up]<Days(365), "Good", Today() - [FS Re-Up])"

The first half works and just don't know how to make it show the number of days if equal to or over 365.

Photo of Tony

Tony

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
It will need to be a formula text field type.

If(Today() - [FS Re-Up]<Days(365), "Good", ToText(ToDays(Today() - [FS Re-Up])))
Photo of Tony

Tony

  • 0 Points
Thank you Mark!!!!!!!!!!