Discussions

 View Only
Expand all | Collapse all

CHECKBOX BASED ON DATE FIELD + days formula assistance

  • 1.  CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 15:44

    checkbox [WARRANTY BILLING]

    =

    If(
    [TO BE BILLED BY:]>(Today()+Days(11)),true,false)
    is not working...

    thank you



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


  • 2.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 15:49

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



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



  • 3.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 15:55

    The checkbox is not being checked

    thx



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



  • 4.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 15:58

    FYI

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

    [CURRENT SCHEDULE DATE]+Days(6)



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



  • 5.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 16:26

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



  • 6.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 17:40



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



  • 7.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 17:44

    Maybe it should be

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

    less than



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



  • 8.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 18:05

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



  • 9.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 18:10

    Great..

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



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



  • 10.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 18:14

    Try this

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



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



  • 11.  RE: CHECKBOX BASED ON DATE FIELD + days formula assistance

    Posted 03-16-2023 18:26

    Whew!  I think that did it.  Seems so simple now.



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