Forum Discussion

Re: CHECKBOX BASED ON DATE FIELD + days formula assistance

Maybe it should be

[TO BE BILLED BY] < =(Today()+Days(11)),true,false)

less than



------------------------------
BuildPro
------------------------------

4 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend

    If you can say in words what you want, then I can help with the formula.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain

      Great..

      If TO BE BILLED BY is 11 or more days in the past (from today), checkbox needs to be checked



      ------------------------------
      BuildPro
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        Try this

        [TO BE BILLED BY] < =Today()-Days(11)



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------