topic All the months between given dates in Application Development and Automation Discussions

All the months between given dates

Former Member — Tue, 10 Apr 2007 08:59:40 GMT

Hi Feriends,

Is there any function module that returns all the months between the given dates.

i.e. if i give 03/2007 in low and 06/2007 in high it should give the 3rd 4th and 5th months.

Please let me know if any ofu have faced the same requirement.......

Thanks,

Chaitanya

Re: All the months between given dates

Former Member — Tue, 10 Apr 2007 09:02:40 GMT

Use the below code:

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.

Thanks

Re: All the months between given dates

Former Member — Tue, 10 Apr 2007 09:08:54 GMT

SELECT-OPTIONS : S_SPMON FOR PGPL-SPMON.

DATA : TOMON(2) TYPE N,

FROMMON(2) TYPE N.

DATA : ITAB LIKE T247 OCCURS 0 WITH HEADER LINE.

FROMMON = S_SPMON-LOW+4(2).

TOMON = S_SPMON-HIGH+4(2).

SELECT * FROM T247 INTO TABLE ITAB WHERE MN BETWEEN FROMMON AND TOMON.

LOOP AT ITAB.

WRITE : / ITAB-KTX,ITAB-LTX.

ENDLOOP.

OR YOU CAN USE FM MONTH_NAMES_GET INSTEAD OF SELECTING DATA FROM T247.

REGARDS

SHIBA DUTTA

Re: All the months between given dates

RaymondGiuseppi — Tue, 10 Apr 2007 09:11:02 GMT

Look at FM CSCP_PARA1_GET_PERIODS.

From a couple of dates, give you a table of beginning of period,

Regards

Re: All the months between given dates

anversha_s — Tue, 10 Apr 2007 09:12:36 GMT

hi,

Check these fm.

MONTHS_BETWEEN_TWO_DATES

MONTHS_BETWEEN_TWO_DATES_NEW

HR_99S_MONTHS_BETWEEN_DATES

HR_MONTHS_BETWEEN_TWO_DATES

Rgds

Anver