Skip to main content

Hi, I'm trying to create a workflow that will send a volunteer thank you email once volunteer hours are marked completed and if their last completed volunteer hours is more than 30 days prior. The field "Last volunteer service date" is updated by workflow whenever volunteer hours are saved as completed. So what I need is how to calculate if the previous field value is more than 30 days prior to the new field value. Here is what I have.

ISPICKVAL( GW_Volunteers__Status__c , "Completed")

&&

GW_Volunteers__Contact__r.GW_Volunteers__Last_Volunteer_Date__c <= ((TODAY()-30))

6 Antworten
  1. 22. Dez. 2014, 17:12
    I'd have to look at your WFR, but in theory the counter would/could be "reset" if they volunteered within the 30 window