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
------------------------------
Original Message:
Sent: 05-26-2022 16:59
From: Zana Skenderi
Subject: Checkbox Formula field for days in the past
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
------------------------------