Forum Discussion

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

Qrew Captain

The checkbox is not being checked

thx

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

Qrew Captain

2 years ago

FYI

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

[CURRENT SCHEDULE DATE]+Days(6)

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

MarkShnier__You
Qrew 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
  Qrew Captain
  2 years ago
  
  ------------------------------
  BuildPro
  ------------------------------
  - BuildPro
    Qrew Captain
    2 years ago
    Maybe it should be
    
    [TO BE BILLED BY] < =(Today()+Days(11)),true,false)
    
    less than
    
    ------------------------------
    BuildPro
    ------------------------------