topic Re: date calculation formula in Application Development and Automation Discussions

date calculation formula

Former Member — Fri, 28 Jul 2006 19:05:55 GMT

Hi Experts,

I need to do a date calculation in one of my programs.

For eg:

data: l_date1 like mch1-fvdt1,

l_maxlz like marc-maxlz,

l_date2 like mch1-vfdat.

the l_date1 and l_date2 are in DATES Format (mmddyyyy)

and l_maxlz is in MONTHS (eg: 12, 14, 20, 24).

i have to add <b>"l_date1" + "l_maxlz"</b> and store it in <b>"l_date2".</b>

Eg: 12/31/2006 + 30 = 06/31/2009

Plz suggest me the formula for calculation.

thnx for the help.

Re: date calculation formula

abdul_hakim — Fri, 28 Jul 2006 19:08:44 GMT

Hi,

Have a look at the Rich's Code...

Re: date calculation formula

RichHeilman — Fri, 28 Jul 2006 19:10:55 GMT

Remember that all dates in SAP are stored as YYYYMMDD regardless of external formatting. Check this sample.




report zrich_0001.

data: l_date1 like mch1-fvdt1,
      l_maxlz like marc-maxlz value '30',
      l_date2 like mch1-vfdat.

l_date1 = '20061231'.

call function 'RE_ADD_MONTH_TO_DATE'
     exporting
          months  = l_maxlz
          olddate = l_date1
     importing
          newdate = l_date2.


write:/ l_date2.

Of course, this will return the date 06/30/2009, because there is no 31st of june.

Regards,

Rich Heilman

Re: date calculation formula

RichHeilman — Fri, 28 Jul 2006 19:11:53 GMT

Abdul, that will not work because you are not handling the change in year.

Regards,

Rich Heilman

Re: date calculation formula

abdul_hakim — Fri, 28 Jul 2006 19:14:20 GMT

Hi Rich,

You are Right..Written it wrongly..

Sam Have a look at Rich's Code..

Cheers,

Abdul Hakim

Re: date calculation formula

Former Member — Fri, 28 Jul 2006 19:21:24 GMT

PERFECT!!!!!!!!!!

thnx a lot, Rich and Abdul