I need a workflow rule that will check a checkbox field called "Store Warranty" when the purchased date is less 7 days when compared to today's date. Example: If the customer bought a product 5 days ago, the checkbox will be checked, but the checkbox should be unchecked if the purchased date is bigger than 8 days when compared to today's date.

  • 1
    Wouldn't a formula field achieve the same purpose without using execution time? There's some precondition to force the workflow approach? Commented Jun 13, 2017 at 15:13

1 Answer 1


Try This one:

Create a New formula field with data type checkbox.

IF(purchased_date__c < Today()-7,False,True)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .