DATE filed Operations....

[Former Member]

hi friends,

When I subtract date1 from date2 I need no. of days and no. of months and no. of years.

Example (1):

date1 : 12.08.2005

date2 : 22.08.2005

answer should be like this. (date2 minus date1)

Days : 10

Months : 0

Years: 0

thanks in advance.

[Former Member]

hi friends,

When I subtract date1 from date2 I need no. of days and no. of months and no. of years.

Example (1):

date1 : 12.08.2005

date2 : 22.08.2005

answer should be like this. (date2 minus date1)

Days : 10

Months : 0

Years: 0

thanks in advance.

[athavanraja]

use FM

FIMA_DAYS_AND_MONTHS_AND_YEARS

just pass i_date_from and i_date_to

Regards

Raja

Message was edited by: Durairaj Athavan Raja

[Former Member]

above solution looks better, except the year is 1 when you have the same year.

I build something like this, its not that nice maybe but it works

DATA: dat1 like sy-datum value '20051110',

dat2 like sy-datum value '20051205',

day_nr type i,

mon_nr type i,

yr_nr type i.

day_nr = dat2 - dat1.

mon_nr = dat24(2) - dat14(2).

yr_nr = dat20(4) - dat10(4).

write: / 'day(s): ',day_nr.

write: / 'month(s): ', mon_nr.

write: / 'year(s): ', yr_nr.

[Former Member]

hi raja,

its giving total no. of days and total no. of months and total no. of years.

but i need different manner. i.e.

from date : 22.07.2003

to date : 10.03.2005

the result should be like this.

days : 12

months: 4

years :2

thanks in advance

[Former Member]

then it will be this

DATA: dat1 like sy-datum value '20030722',

dat2 like sy-datum value '20050310',

day_nr type i,

mon_nr type i,

yr_nr type i.

day_nr = abs( dat26(2) - dat16(2) ).

mon_nr = abs( dat24(2) - dat14(2) ).

yr_nr = abs( dat20(4) - dat10(4) ).

write: / 'day(s): ',day_nr.

write: / 'month(s): ', mon_nr.

write: / 'year(s): ', yr_nr.

Message was edited by: Peter van Alphen