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] &lt; 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------------------------------

zanaskenderi1 · Answer

thank you so much------------------------------Zana Skenderi------------------------------

Forum Discussion

Checkbox Formula field for days in the past

2 Replies

Related Content

Autofill user field when a checkbox is checked

need help with checkbox formula

Formula Checkbox and Duration

Checkbox formula - IsNull URL fields

Formula Date > Text field

Recent Discussions

Pipeline Make Request - Return Make Request JSON Output into fields

Formula using Contain

Moving data from a columnar table to a record based table

Create Child Record, Save and then Edit button

Updating predecessors in a pipeline