Quickbase Discussions

 View Only
  • 1.  Checkbox Formula field for days in the past

    Posted 05-26-2022 16:59
    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
    ------------------------------


  • 2.  RE: Checkbox Formula field for days in the past

    Posted 05-26-2022 17:16

    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
    ------------------------------



  • 3.  RE: Checkbox Formula field for days in the past

    Posted 05-26-2022 17:20
    thank you so much

    ------------------------------
    Zana Skenderi
    ------------------------------