topic Re: Function to get the exact date in Application Development and Automation Discussions

Function to get the exact date

Former Member — Fri, 09 May 2008 05:19:11 GMT

Hi Gurus,

I am searching for a function to get the exact date for certain year.

For example, I would like to know the exact date after 3 years from today.

Because we need to consider the leap year, therefore I cannot do it in this way:

365 (days) * 3 Year(s)

Any suggestion which function I can use here?

All ideas and suggestion are greatly appreciated.

Thanks.

former_member386202 — Fri, 09 May 2008 05:21:26 GMT

Hi,

Use FM RE_ADD_MONTH_TO_DATE

Regards,

Prashant

Former Member — Fri, 09 May 2008 05:23:29 GMT

Hi,

You can use the FM RE_ADD_MONTH_TO_DATE

code

DATA: V_DATE TYPE SYDATUM.

V_DATE = SY-DATUM.

CALL FUNCTION 'RE_ADD_MONTH_TO_DATE'

EXPORTING

MONTHS = '36'

OLDDATE = V_DATE

IMPORTING

NEWDATE = V_DATE.

WRITE: / 'After 3 Years', V_DATE.

Thanks

Former Member — Fri, 09 May 2008 05:27:43 GMT

Thank you so much for the answers.

Especially to Anurodh Jindal, whose provide the example to me as well.

Thanks to all.

Former Member — Fri, 09 May 2008 07:36:32 GMT

Hi Gurus,

I understand that the above function is used for calculate the date after added certain month(s).

But, how do I do it in the other way. What I mean here is I want to substract the date.

For example my current date is 09.05.2008, substract 3 years is 09.05.2005.

All ideas and suggestion are greatly appreciated.

Thanks.