topic Re: date(urgent) in Application Development and Automation Discussions

date(urgent)

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

hello experts

i want to subtract a date from a date suppose

ekko-bedat - mseg-bldat .how shall i do it

plz reply

Re: date(urgent)

Former Member — Fri, 14 Mar 2008 09:47:20 GMT

Hello,

You can do it directly.


data: lv_date like ekko-bedat.
lv_date = ekko-bedat - mseg-bldat.
write: lv_date.

Cheers,

Vasanth

Re: date(urgent)

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

Hi,

u can subtract it directly.then it will give u the diff in number of days.

days = date1 - date2.

rgds,

bharat.

Re: date(urgent)

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

Hi,

You can use the fucntion Module ' DAYS_BETWEEN_TWO_DATES'

Refer the link below :

Please reward points if useful.

Regards

rose

Re: date(urgent)

Former Member — Fri, 14 Mar 2008 09:50:18 GMT

Use the FM /SDF/CMO_DATETIME_DIFFERENCE where you can pass the 2 dates to date1 and date2 parameters to get the difference (in days).

Thanks

Vijay

Re: date(urgent)

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

hello i ahve done it from an internal table

data: d1 type ekko-bedat

d1 = it_ekpo-bedat - it_mseg-bldat.

but the output is comming as 00.00.0000

plz help

Re: date(urgent)

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

declare d1 as type i.

data : d1 type i.

d1 = it_ekpo-bedat - it_mseg-bldat.

Re: date(urgent)

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

Use

DAYS_BETWEEN_TWO_DATES function module.

Award points if useful.

Re: date(urgent)

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

Hello,

Does the two fields it_ekpo-bedat and it_mseg-bldat have values.

If it has the values then definetely the your d1 will give the result.

Cheers,

Vasanth

Re: date(urgent)

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

Hi,

Check this code,

data: date type i.

date =ekko-bedat - mseg-bldat

write: / date.

Thats it. !!..

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

Reward if helpful.

Regards.

Re: date(urgent)

Former Member — Fri, 14 Mar 2008 10:01:22 GMT

> hello i ahve done it from an internal table > data: d1 type ekko-bedat


"here d1 supposed to store number of days.
"so declare d1 as type i NOT 'date' type.
DATA : d1 TYPE i.

> d1 = it_ekpo-bedat - it_mseg-bldat.

> but the output is comming as 00.00.0000

> plz help

Re: date(urgent)

Former Member — Fri, 14 Mar 2008 10:32:12 GMT

hi try this ,

REPORT ZDATEDIFF.

DATA: EDAYS LIKE VTBBEWE-ATAGE,

EMONTHS LIKE VTBBEWE-ATAGE,

EYEARS LIKE VTBBEWE-ATAGE.

PARAMETERS: FROMDATE LIKE VTBBEWE-DBERVON,

TODATE LIKE VTBBEWE-DBERBIS DEFAULT SY-DATUM.

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.

WRITE:/ 'Difference in Days ', EDAYS.

WRITE:/ 'Difference in Months ', EMONTHS.

WRITE:/ 'Difference in Years ', EYEARS.

INITIALIZATION.

FROMDATE = SY-DATUM - 60.

regards,

venkat.