Checkbox Formula field for days in the past

Question

Hi,I am trying to create a formula field to be checked if the day is more than or equal to 14 days or unchecked if more than 14 days. Is this possible to be put in a formula. I started doing the if function but cannot seem to get the 14 days in the past to work.thank you------------------------------Zana ------------------------------

DanielCallahan3 · Answer

If([Your Date Field] < Today() - Days(14), true, false)//you can also use Weeks(2)//the box will check if the value in your date field is more than 14 days in the past------------------------------Daniel Callahan------------------------------

Sign up

Login to the community