Custom Fiscal month and schedule apex class?

Question

We are going to enable Custom fiscal year feature in our org. And there is batch apex class which calculates the opportunity forcast which is scheduled to run 1st of every month ( Standard Fiscal Year ).

If we enable custom fiscal year and add this template 4-4-5 fiscal year that has 4 quarters and 13 weeks per quarter.

I want to schedule the above batch apex class to run on start date of every custom fiscal month(Custom Fiscal year) e.g., for March 2011,start date would be 02/27/2011 . Can we do this through the standard apex scheduler? If not, How to implement this?

Thanks in advance

Answer 1

Hope this helps someone. First, It's not possible with a Cron Expression because Fiscal Years vary unlike Calendar years and Schedulable classes will take Cron Expressions to determine the schedule.

The Fiscal Periods are stored in Period Objects.

global class ScheduledCampaignStageUpdate implements Schedulable {
  
  global void execute(SchedulableContext SC) {
    List<Period> periods = [SELECT StartDate, EndDate, Number FROM Period WHERE FiscalYearSettings.Name >= :currentFiscalYear];
    Date today = Date.today();
    for(Period p: periods) {
      if(today == p.StartDate) {
        // call your Batch Job here
      }
    }
  }
}