KimNguyen
Qrew Member
4 months ago

# Help with a simply IF formula

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 Replies

• 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
------------------------------
• Thank you SOOOOOOO much!!!

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