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,079

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,018

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,019

Hi Wong,

I can understand your requirement.Kindly use FM OIL_DATE_SUBTRACT_MONTH.

Please reward if solved.

Amit.

Read only

0 Likes
1,018

Hi Jony,

Thanks for your answer.

I will not forget to reward you

Read only

0 Likes
1,018

Hi,

myahsam wong do you how to reward?

Read only

0 Likes
1,018

Here is the reward

Read only

Lakshmant1
Active Contributor
0 Likes
1,018

Hi ,

Check FM CCM_GO_BACK_MONTHS

Thanks

Lakshman

Read only

Former Member
0 Likes
1,018

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.