Mark "Active" based on Date

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

I'm looking to write a formula that says:

If Today is any time from the 1st through the 15th of the month

AND

The field [Date] is any time from the 1st through the 15th of the CURRENT month

THEN

Mark "Active"

Any help is greatly appreciated!

Photo of Jennifer

Jennifer

  • 10 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,422 Points 50k badge 2x thumb
Try this as a formula text field

IF(Day(Today()) <= 15 and Day([Date]) <=15, "Active")