Auto Calculate of Promotion price for the items based on Threshold period (Months)

Hi All,

We have threshold promotion which will apply promotion percent or amount off or fixed price based on the two threshold values (Quantity or Amount).

But I have a question which is similar to the threshold promotion, but need to auto calculate the promotion price on different time frames.

We have depreciation value at division level tablewhich have 3 periods

For example:

Yearstarts at 1st Jan XX (Let us assume for division 1)

Period 1-> 3 months (after 31st Mar to 30th Jun XX) - 30%

Period 2-> 4 months (after 30th Jun - 31st Oct XX) - 60%

Period 3 -> 2 months (after 31st Oct XX - 31 Dec XX) - 0%