topic Re: Date utilities function group in Application Development and Automation Discussions

Date utilities function group

Former Member — Wed, 28 Mar 2007 14:10:57 GMT

Is there a standard function group that provides date addition/subtraction utilities? (ie, add a month, add a quarter, go back a week, add a day and remember about leap year, etc.)

Re: Date utilities function group

RichHeilman — Wed, 28 Mar 2007 14:13:44 GMT

Function group SCA4 is a good one, I have used all 3 of these funciton modules.

Regards,

Rich Heilman

Re: Date utilities function group

RichHeilman — Wed, 28 Mar 2007 14:14:53 GMT

You can add and subtract days from a date simply by subracting, it work quite well.

new_date = sy-datum - 7.

Regards,

Rich Heilman

Re: Date utilities function group

RichHeilman — Wed, 28 Mar 2007 14:15:58 GMT

Function group CADA is good for working with weeks.

Regards,

Rich Heilman

Re: Date utilities function group

Former Member — Wed, 28 Mar 2007 14:17:35 GMT

Hi Kristen,

Try this function module:

call function 'RP_CALC_DATE_IN_INTERVAL'

exporting

date = sy-datum

days = 1

months = 0

signum = '-'

years = 0

importing

calc_date = l_date.

Give '+' or '-' in signum for add or subtract days

Thanks,

Raj.

Re: Date utilities function group

ferry_lianto — Wed, 28 Mar 2007 14:19:36 GMT

Hi,

Please use this FM RP_CALC_DATE_IN_INTERVAL.

It handles leap year date calcalution as well.

Regards,

Ferry Lianto

Re: Date utilities function group

Former Member — Wed, 28 Mar 2007 14:26:14 GMT

RP_CALC_DATE_IN_INTERVAL is almost perfect. However, when I enter 3/31/07 as the date and +3 months, it gives 7/1/07. I need it to respond 6/30/07...

Re: Date utilities function group

ferry_lianto — Wed, 28 Mar 2007 14:31:39 GMT

Hi,

I think it is the correct calculation for adding 3 months from the given date.

But you can always subtract by 1 day from the FM's result to meet your requirement for end of the month date calculation.


data: wa_idate like sy-datum,
      wa_odate like sy-datum.

move '20070331' to wa_idate.

call function 'RP_CALC_DATE_IN_INTERVAL'
         exporting
              date      = wa_idate
              days      = 0
              months    = 3
              signum    = '+'
              years     = 0
         importing
              calc_date = wa_odate.

wa_odate = wa_odate -1.

write: / wa_odate.

Regards,

Ferry Lianto