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. ------------------------------ Bri...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
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
------------------------------
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
------------------------------
- Thanks Mark, that worked perfectly
------------------------------
Brian Brian
------------------------------
