Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
3 years ago

Checkbox is date is greater than another date

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 Replies

  • 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
    ------------------------------
    • BrianPierron's avatar
      BrianPierron
      Qrew Trainee
      Thanks Mark, that worked perfectly

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