I am assuming end date is a field on your Account detail page.
How do you qualify an account ot be inactive? Is there a check box on the Account detail page that is checked /unchecked to mark this status? If yes, you can create a workflow and make a fieldup as soon as the end date is crossed. reference:https://help.salesforce.com/HTViewHelpDoc?id=workflow_defining_field_updates.htm&language=en_US
Sorry, didn't quite get that last update you gave..do you mean the end date is on a custom object record?
Please explain the flow completely so I can suggest better..where is the end date field? is it on a custom object record? If yes, do you want all the accounts related to this custom object record to be turned to inactive?
Create one custom object like survey which should store details like survey ID, name, survey start and end date etc. and make all the surveys become inactive automatically after survey end date
I suppose we would need to schedule a apex class(http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_scheduler.htm) in this scenario as I understand the custom object will not be updated daily( to be able to trigger the workflow we setup)
What you can do is - 1)create a checkbox on the custom object as I suggested, to mark the status of the survey as active/inactive 2)Write an apex clas to update the checkbox if the end date < TODAY() 3)Schedule this apex class to run every midnight so all surveys with past end date get checked as inactive.
If we were updating the records everydays - we could have applied a workflow thus making this declarative.Is that the case in your setup? If yes, you can go with the worflow, set the trigger criteria to each time its updated and have the field update setup to update the checkbox.
How do you qualify an account ot be inactive? Is there a check box on the Account detail page that is checked /unchecked to mark this status? If yes, you can create a workflow and make a fieldup as soon as the end date is crossed.
reference:https://help.salesforce.com/HTViewHelpDoc?id=workflow_defining_field_updates.htm&language=en_US
Please explain the flow completely so I can suggest better..where is the end date field? is it on a custom object record? If yes, do you want all the accounts related to this custom object record to be turned to inactive?
What you can do is -
1)create a checkbox on the custom object as I suggested, to mark the status of the survey as active/inactive
2)Write an apex clas to update the checkbox if the end date < TODAY()
3)Schedule this apex class to run every midnight so all surveys with past end date get checked as inactive.