Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

CHECKBOX BASED ON DATE FIELD + days formula assistance

checkbox [WARRANTY BILLING] = If( [TO BE BILLED BY:]>(Today()+Days(11)),true,false) is not working... thank you ------------------------------ BuildPro ------------------------------
BuildPro's avatar
BuildPro
Qrew Captain

The checkbox is not being checked

thx



------------------------------
BuildPro
------------------------------
BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

FYI

[TO BE BILLED BY:] is a date forumla field

[CURRENT SCHEDULE DATE]+Days(6)



------------------------------
BuildPro
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago

    The pretty simple formula so it certainly should work.

    Can you prove with a screenshot on a particular record or on a report that it is not working? i.e. show me a screenshot where the [TO BE BILLED BY:] is more than 11 days in the future so after say March 29th and the checkbox is not checked?



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



      ------------------------------
      BuildPro
      ------------------------------
      • BuildPro's avatar
        BuildPro
        Qrew Captain
        2 years ago

        Maybe it should be

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

        less than



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