Discussions

Expand all | Collapse all

Checkbox is date is greater than another date

  • 1.  Checkbox is date is greater than another date

    Posted 07-04-2021 17:51
    I'm looking for a formula that can mark a checkbox true if "Date Created" is 3 or more days greater than "Date Received".

    Any assistance would be appreciated.

    ------------------------------
    Brian Brian
    ------------------------------


  • 2.  RE: Checkbox is date is greater than another date

    Posted 07-04-2021 19:15
    np,

    ToDate([Date Created]) >= [Date Received] + Days(3)

    I'm assuming here that [Date Created] is the native date / time field for when the record was created, but that [Date Received] is just a regular date field.

    If it makes it easier to understand the formula, you can also use this longer syntax. But they are logically the same.

    IF(ToDate([Date Created]) >= [Date Received] + Days(3), true)


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Checkbox is date is greater than another date

    Posted 30 days ago
    Thanks Mark, that worked perfectly

    ------------------------------
    Brian Brian
    ------------------------------