Apex Code Development You need to sign in to do that
Don't have an account?
nimdhar TimeBased Workflow to run once an year
Hi All,
Scenario
Account has two fields Current Total Year to date count(which stores count of some records for current year) and Previous Total Year to date count (which stores count of some records for the previous year). At the end of the year I need to update Previous Total Year to date count with Current Total Year to date count and Current Total Year to date count to zero.
Possible Solution
I created a AccountBatch Object which has NextRunTime variable and in my Time Based workflow I set my workflow to run after 0 hrs NextRuntime and update some field in AccountBatch Object which runs my trigger to do the above mentioned logic. But my workflow doesn't run at the time I mentioned in the NextRunTime. It runs only when I update my AccountBatch.
Any suggestions on how to solve the above problem is greatly appreciated.
Thanks,
Nimdhar
Scenario
Account has two fields Current Total Year to date count(which stores count of some records for current year) and Previous Total Year to date count (which stores count of some records for the previous year). At the end of the year I need to update Previous Total Year to date count with Current Total Year to date count and Current Total Year to date count to zero.
Possible Solution
I created a AccountBatch Object which has NextRunTime variable and in my Time Based workflow I set my workflow to run after 0 hrs NextRuntime and update some field in AccountBatch Object which runs my trigger to do the above mentioned logic. But my workflow doesn't run at the time I mentioned in the NextRunTime. It runs only when I update my AccountBatch.
Any suggestions on how to solve the above problem is greatly appreciated.
Thanks,
Nimdhar