Discussions

View Only

Help with a simply IF formula

• 1.  Help with a simply IF formula

Posted 22 days ago

Hello!

I have a check box that I would like CHECKED when:

• Referenced Date Field is after January 1, 2024
• All days before 1/1/24 is UNCHECKED
• It has been at least 7 days since Referenced Date Field
• If Referenced Date Field = 2/1/24, then it's checked if TODAY() = 2/8/24

Here is the formula I have. The +7 days portion works but the before 1/1/24 doesn't work :(

If([Date Field] + Days(7) <= Today()

and

[Date Field] > ToDate(01/01/2024),

true, false)

Thank you in advance if you are able to help me solve

------------------------------
Kim Anh Nguyen
------------------------------

• 2.  RE: Help with a simply IF formula

Posted 22 days ago

If I'm understanding correctly you just need to make sure that anything before 1/1/24 is unchecked? You can do a condition that specifically calls that out like so if that's what you need:

if(

[Date Field] < ToDate("1/1/24"), false,

[Date Field] + Days(7) <= Today(), true,

false)

------------------------------
Chayce Duncan
------------------------------

• 3.  RE: Help with a simply IF formula

Posted 22 days ago

Thank you SOOOOOOO much!!!

------------------------------
Kim Anh Nguyen
------------------------------