Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Function to get the date after substraction

Former Member
0 Likes
1,077

Hi Gurus,

I understand that the function "RE_ADD_MONTH_TO_DATE" 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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
1,016

Hi Wong,

I can understand your requirement.Kindly use FM OIL_DATE_SUBTRACT_MONTH.

Please reward if solved.

Amit.

Hi Gurus,

I understand that the function "RE_ADD_MONTH_TO_DATE" 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.

6 REPLIES 6
Read only

Former Member
0 Likes
1,017

Hi Wong,

I can understand your requirement.Kindly use FM OIL_DATE_SUBTRACT_MONTH.

Please reward if solved.

Amit.

Read only

0 Likes
1,016

Hi Jony,

Thanks for your answer.

I will not forget to reward you

Read only

0 Likes
1,016

Hi,

myahsam wong do you how to reward?

Read only

0 Likes
1,016

Here is the reward

Read only

Lakshmant1
Active Contributor
0 Likes
1,016

Hi ,

Check FM CCM_GO_BACK_MONTHS

Thanks

Lakshman

Read only

Former Member
0 Likes
1,016

Hi ,

u can use the same function module RE_ADD_MONTH_TO_DATE with passing months in negetive number like,

month = -36.

in the function module.

regards,

kk.