topic Re: date. in Application Development and Automation Discussions

date.

Former Member — Wed, 28 Jun 2006 08:07:11 GMT

Hi all,

Could u tell me how to add/subtract some no of months to a particular date and get the resulting date..

Thanks

Ananda

Re: date.

Former Member — Wed, 28 Jun 2006 08:10:16 GMT

Use the below function module...

data : wa_date type sy-datum.

call function 'RP_CALC_DATE_IN_INTERVAL'

exporting

date = sy-datum

days = 0

months = 6

years = 0

signum = '+'

importing

calc_date = wa_date.

<b>signum = '+' " add month

signum = '-' " subtract month</b>

Pl. award points if useful.

Re: date.

Former Member — Wed, 28 Jun 2006 08:10:36 GMT

Hi,

you can use these two funcion odules.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

DATE = IT_HEADER-INVOICE_DATE

DAYS = '00'

MONTHS = '01'

SIGNUM = '-'

YEARS = '00'

IMPORTING

CALC_DATE = BILLING_PERIOD-LOW

CALL FUNCTION 'HR_SEN_CALE_DAYS_DATE'

EXPORTING

ID_DATE = V_DATE

ID_OPERATOR = '+'

IS_DURATION = V_DURATION

IMPORTING

ED_DATE = V_PAYMENT_DUE

EXCEPTIONS

CONVERSION_NOT_SPECIFIED = 1

CONVERSION_NOT_POSSIBLE = 2

OTHERS = 3.

IF SY-SUBRC <> 0.

reward if you find this helpful.

regards,

sumit

Message was edited by: sumit kumar

Re: date.

Former Member — Wed, 28 Jun 2006 08:11:28 GMT

Hi,

Copy and paste this code.

REPORT ZTEST .

data : l_month type i value '2'.

data : l_date type sy-datum value '20060505',

l_date_new type sy-datum.

CALL FUNCTION 'RE_ADD_MONTH_TO_DATE'

EXPORTING

MONTHS = l_month

OLDDATE = l_date

IMPORTING

NEWDATE = l_date_new.

write : l_date_new.

Message was edited by: mukesh kumar

Re: date.

Laxmana_Appana_ — Wed, 28 Jun 2006 08:13:00 GMT

Hi,

Use the FM's:

MONTH_PLUS_DETERMINE

CCM_GO_BACK_MONTHS

Laxman

Re: date.

Simha_ — Wed, 28 Jun 2006 08:13:11 GMT

Hi,

Use F.M <b>HR_99S_INTERVAL_BETWEEN_DATES</b>

Cheers,

Simha.

Re: date.

Former Member — Wed, 28 Jun 2006 08:13:55 GMT

Hi,

Use FM

MONTH_PLUS_DETERMINE.

Regards,

Shashank

Re: date.

Former Member — Wed, 28 Jun 2006 08:34:02 GMT

Hi Herath,

U can use this function module :

BKK_ADD_MONTH_TO_DATE

U can pass negative values to deduct and positive values to add months to the date.