topic Re: Dates between 2 dates - FM in Application Development and Automation Discussions

Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 16:43:24 GMT

Guys,

Can somebody please let me know the FM, that will give me the dates between 2 dates?

Thanks in advance....

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 16:47:27 GMT

You don't need any fm (and I don't know if there's any one):

DATA: DAY_1 TYPE SY-DATUM   VALUE '20081020',
           DAY_2 TYPE SY-DATUM   VALUE '20081231'.

DATA: DAY TYPE SY-DATUM.


DO.
  DAY = DAY_1 + 1.
  IF DAY = DAY_2.
     EXIT.
  ENDIF.
  WRITE / DAY.
ENDDO.

Max

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 16:47:57 GMT

Have you tried searching yourself?

Rob

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 16:52:18 GMT

This might be the 10th time I am seeing this question in the last couple of weeks.

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:05:03 GMT

Rob,

I did try, and then only I posted it on the forum. I found those are not relevent to me.

MxG,

I have not found it when I searched it.

I would have appriciated had you answered it.

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:08:42 GMT

Hi Sam,

Check out the Function Module


RKE_SELECT_FACTDAYS_FOR_PERIOD 

Or 

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.

Thanks,

Chidanand

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:11:15 GMT

So, didn't Max's solution help?

Rob

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:19:06 GMT

Hi,

Sorry to enter into discussion in the middle.

I tried to execute max's code but it took me to DUmp and its serious error my system adminstartor has given worng regarding this program. He said highly memory consuming code and may damage kernal . i think its so strange.

When i tried to find where the error occurs its in the write statement

write:/ day.

Program is requesting for 740232384 bytes.

Regards

Balu

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:25:27 GMT

Not really a serious error - I don't see how it could damage the kernel. But yes, it's in an infinite loop.

Rob

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:28:38 GMT

you should have seen Do .. enddoo w/o any exit point.

Re: Dates between 2 dates - FM

BH2408 — Tue, 21 Oct 2008 18:29:18 GMT

Hi ,

this is FM for the finding the diff b/w 2 dats.

FIMA_DAYS_BETWEEN_TWO_DATES.

Regards,

Bharani

Re: Dates between 2 dates - FM

Former Member — Tue, 21 Oct 2008 18:34:21 GMT

we can correct the code.

DATA: DAY_1 TYPE SY-DATUM   VALUE '20081020',
           DAY_2 TYPE SY-DATUM   VALUE '20081231'.

DO.

  IF DAY_1 = DAY_2.
     EXIT.
  ENDIF.
  WRITE / DAY_1.
  DAY_1 = DAY_1 + 1.
ENDDO.

Re: Dates between 2 dates - FM

uwe_schieferstein — Tue, 21 Oct 2008 18:57:10 GMT

Hello Sam

Class CL_RECA_DATE provides many useful methods, e.g.:

GET_DATE_DIFF
GET_DAYS_BETWEEN_TWO_DATES

Another interesting classes is CL_RECA_DATE_SLICES.

Regards

Uwe

Re: Dates between 2 dates - FM

Former Member — Wed, 22 Oct 2008 15:27:30 GMT

Sorry for responding late, Max's code worked for me. Actually it was simple but did not strike to me before. I had to make minor changes.

Thanks all.