+ Start a Discussion
nimdharnimdhar 

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