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 ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend

Can you explain what is not working?  What is the symptom of the problem?



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

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
      Icon for Qrew Legend rankQrew Legend
      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
        ------------------------------