I have a requirement to calculate next quater month based on the provided month and using the derived quarter month value need to calcuate the next earliest quarter month.
For example I have a date 2005-05-20 next 4 quarters based on this dates are 08, 11,02,05 months respectively, Then i need to check the current month value (2006-03-09) so that is is '03'. as per logic i want next earliest quarter would be 05 .
Code: Select all
InDate InMonth Possible quarters required qtr
2005-05-20 05 08 11 02 05 05(as it is the next)
2005-03-10 03 06 09 12 03 03(as it is equal)
2005-01-01 01 04 07 10 01 04(as 01 is past 04 is next)
Is there any way i can do in PX using StageVariables, any help is appreciated.
~
Code: Select all