Forumla to determine when its 60 days before Today

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

I need a formula to:

If

Today - [Next Due Date] <= 60 days but > 1 day to say "60 Day Warning" in red & bold

or >60 days but <= 90 days to say "90 Day Warning" in just an orange no bold

or >90 days to be null


Thank you in advance

Photo of Tony

Tony

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
Try this:

var Number DaysToNextDueDate = ToDays ( [Next Due Date] - Today() );

If (


$DaysToNextDueDate > 1 and $DaysToNextDueDate <= 60, "<font color='red'><b>" & "60 Day Warning" & "</b></font>",

$DaysToNextDueDate > 60 and $DaysToNextDueDate <= 90, "<font color='orange'>" & "90 Day Warning" & "</font>",

""

)
Photo of Tony

Tony

  • 0 Points
PERFECT!!!!!!!!!!!!!! Thank you very much!
Photo of Xavier Fan

Xavier Fan, Champion

  • 410 Points 250 badge 2x thumb
You're welcome!