topic Re: Function module for Date calculation in Application Development and Automation Discussions

Function module for Date calculation

Former Member — Wed, 12 Nov 2008 16:38:50 GMT

hi,

I have a requirement to check a Date exactly 12 months back from the present day when my function module is called.

Is there a SAP standard function module to do this manipulation?

Presently i have used the following code,

LV_DATUM = SY-DATUM

LV_DATUM = LV_DATUM - 365.

The problem in the above code is not knowing the Leap year dynamically, which means it would sometimes be less than 365 days.

Regards,

Raja

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 16:48:22 GMT

Hi Raja,

Try HRWPC_BL_DATES_MONTH_INTERVAL

Re: Function module for Date calculation

JozsefSzikszai — Wed, 12 Nov 2008 16:51:13 GMT

just try the following (no FM is necessary):

lv_datum = sy-datum.
lv_datum(4) = lv_datum(4) - 1.

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 16:54:46 GMT

Hi,

Try this FM "MONTH_PLUS_DETERMINE"

Add or subtract months from a date. To subtract a month, enter a negative value for the 'months' parameter.

Regards,

Chithra

Re: Function module for Date calculation

former_member156446 — Wed, 12 Nov 2008 17:04:31 GMT

DATA:lv_date TYPE d.
lv_date = '20000504'.

lv_date+0(4) = lv_date+0(4) - 1.

WRITE:/ lv_date.

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:28:36 GMT

And what about if the date was '20080229' how owuld your code work in that case?

Re: Function module for Date calculation

ThomasZloch — Wed, 12 Nov 2008 17:33:33 GMT

What would be the expected result, 20070228 or 20070301?

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:35:29 GMT

Check this fm CALCULATE_DATE

Regards

Gregory

Re: Function module for Date calculation

former_member156446 — Wed, 12 Nov 2008 17:48:15 GMT

Hi MXG

check it

DATA:lv_date TYPE d.
lv_date = '20080229'.   " value you gave

lv_date+0(4) = lv_date+0(4) - 1.

WRITE:/ lv_date.

outoput: 02292007

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:50:41 GMT

yes and then what to do with the date value 02/29/2007?

Re: Function module for Date calculation

former_member156446 — Wed, 12 Nov 2008 17:52:53 GMT

date will always be stored in YYYYMMDD format in SAP, specially in debug mode and in DB level.. its just the output or the conversion routines which shows us the ouput as per system settings...

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:54:44 GMT

do you see 20070229 or 02/29/2007 as a valid date?

got it ?

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:55:32 GMT


> outoput: 02292007

Was this date came in our life?

Re: Function module for Date calculation

former_member156446 — Wed, 12 Nov 2008 17:56:35 GMT

date - 1year is the concept and the logic works

logic is writen in SAP _ ABAP not in Visual basics chill..

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 17:58:11 GMT

I guess you still dont get it.

try putting date as 02/29/2007 on any SAP date field on any screen

Re: Function module for Date calculation

former_member156446 — Wed, 12 Nov 2008 18:04:43 GMT

Re: Function module for Date calculation

Former Member — Wed, 12 Nov 2008 18:12:41 GMT

FM RP_CALC_DATE_IN_INTERVAL worked fine for me

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'

EXPORTING

date = '02/29/2008'

days = '0'

months = '0'

signum = '-'

years = '01'

IMPORTING

calc_date = p_bsdte.

i got p_bsdte = 02/28/2007.

Re: Function module for Date calculation

Former Member — Thu, 13 Nov 2008 05:07:09 GMT

Try this too:

DATA:

l_year1 TYPE i,

l_year2 TYPE p DECIMALS 2,

l_date TYPE sy-datum.

PARAMETER: datum TYPE sy-datum.

l_year1 = datum(4) / 4.

l_year2 = datum(4) / 4.

IF l_year1 EQ l_year2.

l_date = datum - 365.

ELSE.

l_date = datum - 366.

ENDIF.