topic Re: Function Module days into months & year..... in Application Development and Automation Discussions

Function Module days into months & year.....

former_member259275 — Fri, 29 Jun 2007 06:54:22 GMT

Hii can anyone tell me which function module is used to convert no of days into days,month & year....

SHOAIB

Re: Function Module days into months & year.....

Former Member — Fri, 29 Jun 2007 06:56:43 GMT

Check the following fun modules

DAYS_BETWEEN_TWO_DATES

LEAP_DAYS_BETWEEN_TWO_DATES

HR_SEN_CALE_DAYS_DATE

ISB_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES_2

FIMA_LEAP_DAYS_BETWEEN_2_DATES

Kishi.

Re: Function Module days into months & year.....

Former Member — Fri, 29 Jun 2007 07:00:22 GMT

hi ,

just check this code this might help u ....

DATA: V_INPUT(4) VALUE '7093'.

DATA: V_DATE TYPE SYDATUM.

DATA: V_OUTPUT TYPE CHAR10.

CONCATENATE '200' V_INPUT(1) '0101' INTO V_DATE.

V_DATE = V_DATE + V_INPUT+1(3) - 1.

WRITE V_DATE TO V_OUTPUT MM/DD/YYYY.

WRITE: / V_OUTPUT.

regards

reena

Re: Function Module days into months & year.....

Former Member — Fri, 29 Jun 2007 07:00:49 GMT

hi rehman,

i am not sure whether any FM exists that returns no.of days ,months and years. But there is a FM FIMA_DAYS_AND_MONTHS_AND_YEARS which will return no of days, yrs, months b/w two dates.

regards,

alson

Re: Function Module days into months & year.....

Former Member — Fri, 29 Jun 2007 07:07:08 GMT

Hi,

RELATIVE_DATE_CALCULATE

RP_CALC_DATE_IN_INTERVAL

Thanks,

Anitha

Re: Function Module days into months & year.....

Former Member — Fri, 29 Jun 2007 12:36:19 GMT

Hi,

FM: 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

Ex.

REPORT ZDATEDIFF.

DATA: EDAYS LIKE VTBBEWE-ATAGE,

EMONTHS LIKE VTBBEWE-ATAGE,

EYEARS LIKE VTBBEWE-ATAGE.

PARAMETERS: FROMDATE LIKE VTBBEWE-DBERVON,

TODATE LIKE VTBBEWE-DBERBIS DEFAULT SY-DATUM.

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = FROMDATE

i_date_to = TODATE

I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = EDAYS

E_MONTHS = EMONTHS

E_YEARS = EYEARS.

WRITE:/ 'Difference in Days ', EDAYS.

WRITE:/ 'Difference in Months ', EMONTHS.

WRITE:/ 'Difference in Years ', EYEARS.

INITIALIZATION.

FROMDATE = SY-DATUM - 60.

Regards,

Bhaskar