Function module for Date calculation

[Former Member]

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

[Former Member]

Hi Raja,

Try HRWPC_BL_DATES_MONTH_INTERVAL

[JozsefSzikszai]

just try the following (no FM is necessary):

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

[Former Member]

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

[former_member156446]

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

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

WRITE:/ lv_date.

[Former Member]

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

[ThomasZloch]

What would be the expected result, 20070228 or 20070301?

[former_member156446]

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

[Former Member]

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

[former_member156446]

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...

[Former Member]

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

got it ?

[Former Member]

>

> 
outoput: 02292007

Was this date came in our life?

[former_member156446]

date - 1year is the concept and the logic works

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

[Former Member]

I guess you still dont get it.

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

[Former Member]

Hi

Check this fm CALCULATE_DATE

Regards

Gregory

[Former Member]

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.

[Former Member]

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.