topic Date Calculations in Application Development and Automation Discussions

Date Calculations

Former Member — Mon, 18 Nov 2013 21:12:24 GMT

Hello,

I am working on a new function module where on the selection screen i have the period type ( allowed values are 'D','W','M' for day,week and month).

And have one more input for date_period(it will allow integer upto 999).

My requirement is to calculate a date based on the period_type and date_period.

For example, if the period_type is 'M' (monthly) and date_period is 10, then the date should be current date + 10 months.

if the period_type is 'W' (weekly) and date_period is 10, then the date should be current date + 10 weeks.

And the same with 'D'.

Please note that i am working in APO environment. There is a FM module in ECC 'RP_CALC_DATE_IN_INTERVAL' which mostly matches my requirement but its not available in APO.

Any help would be appriciated.

Re: Date Calculations

Sougata — Mon, 18 Nov 2013 22:20:57 GMT

Hi,

If you have Class CL_RECA_DATE available in your APO system, you could work with its static methods especially ADD_TO_DATE looks promising in regards to your requirement.

Cheers,

Sougata.

Re: Date Calculations

Former Member — Tue, 19 Nov 2013 14:32:50 GMT

Unfortunatley, i do not see that class available in our APO system.

Re: Date Calculations

eduardo_hinojosa — Tue, 19 Nov 2013 14:46:22 GMT

For adding months, you can try with the FM 'MONTH_PLUS_DETERMINE'.

For weeks I don't know any standard FM. Think that each 7 or 8 years there is a year of 53 weeks. You can create your own FM, if for instance you want to add 10 weeks, obtain days (ie: 10 * 7 = 70 days), add these days to the original date and with the FM 'DATE_GET_WEEK' get the weeks for the first day and the calculated day.

I hope this helps you

Regards

Eduardo

Re: Date Calculations

Former Member — Tue, 19 Nov 2013 14:49:19 GMT

'MONTH_PLUS_DETERMINE' looks like an ECC Function module.

My requirment is in APO.

Re: Date Calculations

Former Member — Tue, 19 Nov 2013 16:00:34 GMT

Found the FM - SEPA_MANDATE_ADD_MONTH_TO_DATE which works for month.

But still need a solution for weeks.

Re: Date Calculations

Former Member — Tue, 19 Nov 2013 16:08:34 GMT

Can you not code your own logic for weeks?

End date = Start date + (7 * number of weeks).

Regards,

Nick