topic Re: Date arithmetic...have ur points.. in Application Development and Automation Discussions

Date arithmetic...have ur points..

Former Member — Tue, 04 Sep 2007 03:54:40 GMT

Hi all,

I want to do arithmetic operations on date type fields..

like i want to add 5 days to current date...like this..

Pleas help me...

& have ur points..

Regards,

pradeep

Re: Date arithmetic...have ur points..

Former Member — Tue, 04 Sep 2007 03:57:52 GMT

Hi,

check the function module:

RP_CALC_DATE_IN_INTERVAL

regards,

Navneeth K.

Re: Date arithmetic...have ur points..

kiran_k8 — Tue, 04 Sep 2007 03:58:11 GMT

Pradeep,

Try this function module

DATE_IN_FUTURE ? takes number of days and date - gives future date in user format and system format

K.Kiran.

Re: Date arithmetic...have ur points..

Former Member — Tue, 04 Sep 2007 03:59:51 GMT

hi check this code,

data : days type i,fdate type sy-datum, ldate type sy-datum.

fdate = sy-datum. " todays date

ldate = fdate + 2. " add 2 days

days = ldate - fdate. " days will be 2.

do modifications according to ur requirement

Re: Date arithmetic...have ur points..

Former Member — Tue, 04 Sep 2007 04:02:32 GMT

Hi Pradeep,

If you want to add 5 working days to current date then you need to convert the date to factory date first passing country id and the date

DATE_CONVERT_TO_FACTORYDATE

then add 5 to the returned number and convert the value to date type using

FACTORYDATE_CONVERT_TO_DATE

Award points if this is helpful.

Regards,

Ravi G

Re: Date arithmetic...have ur points..

varma_narayana — Tue, 04 Sep 2007 04:25:33 GMT

Hi Pradeep...

Find some of the useful date operations here.

Data : v_date1 like sy-datum.

Data : v_date2 like sy-datum.

Data : v_diff type i.

**Assigning date variables

v_date1 = sy-datum.

v_date2 = sy-datum.

**Extract the individual parts of date

v_date1+6(2) = '01' . "set the Day as the First day of the month

write:/ v_date1.

**Adding no of days.

v_date2 = v_date2 + 5.

write: v_date2.

**Subtracting two date fields

v_diff = v_date2 - v_date1.

write:/ v_diff.

Additionally you can find various FMs to process dates.

Some of them can be found in Function group SCAL.

<b>REWARD POINTS IF HELPFUL.</b>