CHECKBOX BASED ON DATE FIELD + days formula assistance

Question

checkbox [WARRANTY BILLING]
=
If([TO BE BILLED BY:]&gt;(Today()+Days(11)),true,false)is not working...
thank you------------------------------BuildPro------------------------------

markshnier__you · Answer

Can you explain what is not working?&nbsp; What is the symptom of the problem?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

buildpro · Answer

The checkbox is not being checked
thx------------------------------BuildPro------------------------------

buildpro · Answer

FYI
[TO BE BILLED BY:] is a date forumla field
[CURRENT SCHEDULE DATE]+Days(6)------------------------------BuildPro------------------------------

markshnier__you · Answer

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

buildpro · Answer

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

Forum Discussion

CHECKBOX BASED ON DATE FIELD + days formula assistance

10 Replies

Related Content

Formula Assistance

Formula checkbox using manual checkbox and lookup formula

Admin Assistance

QrewTip: Formula Logic Order

Combining AND with OR in Formula Checkbox Field