Functions - Checkbox to be true if within the past 10 days?

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

I have a formula checkbox I want checked only if it falls within the last 10 days. That would be from today less 10 days....If([Date]= (Today() -Days(1)),true,false)....Anyone know how to make the days include 10 previous?

Photo of Joshua

Joshua

  • 0 Points

Posted 5 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,558 Points 50k badge 2x thumb
if(ToDays(Today()-[date field])<=10,true)

or simply


ToDays(Today()-[date field])<=10