2 Replies Latest reply on Aug 19, 2019 4:47 PM by Mark Francome

    Using a calendar as a variable in a job

    Andrew Curry
      Share This:

      I am not sure if this will make sense or is even possible. But we have a developer that wants to run a job that acts on data from the prior fiscal month and prior fiscal year. We have fiscal calendars setup for scheduling jobs and I am wondering if it is possible to pass fiscal periods from that calendar to the job as a variable. The key is that not all fiscal periods are simply days 1-30 or 1-31, but might include days from the prior month.

       

      For example we have 12 periods defined - A,B,C,D,E,F,G,H,I,J,K,L

       

      If we want to pass the July fiscal period to the job as a variable we would use G. So something like current period - 1 or previous period as the value of the variable.