Skip to main content
Question

Help with a simply IF formula

  • February 7, 2024
  • 0 replies
  • 57 views
Forum|alt.badge.img+1

Hello!

I have been stuck on this problem for HOURS. Please help :'(

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
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Quickbase Alumni
    • February 7, 2024

    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
    ------------------------------
      Terms & ConditionsAccessibility statement