topic Re: Issue on Dates in Application Development and Automation Discussions

Issue on Dates

Former Member — Fri, 14 Mar 2008 09:51:21 GMT

Hi,

I want to subtract the two dates and get the no of days between them.

For ex: 20080314(YYYYMMDD) - 20031102

I want to get no of days between these two dates

Can anyone help on these

Thanks in advance.

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:53:05 GMT

Hi,

if the variables which are holding these variables are sy-datum or some other date types then u can do direct subtraction.

rgds,

bharat.

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:53:31 GMT

just subtract one date from other ...

data : v_date1 like sy-datum,

v_date2 like sy-datum.

data : v_diff type i.

v_diff = v_date2 - v_date1.

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:53:48 GMT

Hello,

Use this sample code:


data:  G_F_DIFF TYPE I
  CLEAR G_F_DIFF.
  CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES'
       EXPORTING
            I_DATUM_BIS             = G_T_PURO-AEDAT
            I_DATUM_VON             = G_T_EBAN-BADAT
       IMPORTING
            E_TAGE                  = G_F_DIFF
       EXCEPTIONS
            DAYS_METHOD_NOT_DEFINED = 1
            OTHERS                  = 2.
write: g_F_diff.

Cheers,

Vasanth

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:54:06 GMT

Hi,

Use the FM : 'DAYS_BETWEEN_TWO_DATES'

data: G_F_DIFF TYPE I

CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES'

EXPORTING

I_DATUM_BIS = G_T_PURO-AEDAT " Enddate

I_DATUM_VON = G_T_EBAN-BADAT " Start Date

IMPORTING

E_TAGE = G_F_DIFF

EXCEPTIONS

DAYS_METHOD_NOT_DEFINED = 1

OTHERS = 2.

write: g_F_diff.

Please reward points if useful.

Regards

Rose

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:55:43 GMT

Hi,

Use FM DAYS_BETWEEN_TWO_DATES to get days

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 09:56:40 GMT

hi,

you can add/subtract dates directly if the type is SY-DATUM.

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 10:00:13 GMT

Hi,

Check this code,

data: date type i.

date = 20080314 - 20031102.

write: / date.

Thats it. !!..

You can also have the date fields in two variables if you want to.

Reward if helpful.

Regards.

Re: Issue on Dates

Former Member — Fri, 14 Mar 2008 10:02:38 GMT

Hi Srinivas,

Thanks a lot.........