Checkbox is date is greater than another date

Question

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

markshnier__you · Answer

np,ToDate([Date Created]) &gt;= [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]) &gt;= [Date Received] + Days(3), true)------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

brianpierron · Answer

Thanks Mark, that worked perfectly------------------------------Brian Brian------------------------------

Forum Discussion

Checkbox is date is greater than another date

2 Replies