topic Re: regarding date in Application Development and Automation Discussions

regarding date

former_member842213 — Thu, 18 Jan 2007 06:30:19 GMT

hi ,

I want to subtract 13 months from a date.

'OIL_DATE_SUBTRACT_MONTH' this fm is going for dump...

can anybody suggest sme other fn module to do the same.

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:31:54 GMT

try CALCULATE_DATE

Check this program contributed by Andreas


with month = -13

REPORT zforum117 .


PARAMETERS: date LIKE sy-datum DEFAULT sy-datum,
mth(4) default -1.
DATA: fecha LIKE sy-datum(6),
fecha1 LIKE sy-datum.

CALL FUNCTION 'CALCULATE_DATE'
EXPORTING
* days = '0'
months = mth
start_date = date
IMPORTING
result_date = fecha1.
.


fecha = fecha1(6).

write: fecha.

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:35:04 GMT

try fm

MONTH_PLUS_DETERMINE

regards

shiba dutta

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:35:06 GMT

Well, the easiest thing to do is to simply subsract a number (of days) to a date.

data: w_date like sy-datum.
w_date = sy-datum.
w_date = w_date - 90.
* w_date has a date 90 days of the past.
 
 
But if you have to add or substract months or years, you can use FM RP_CALC_DATE_IN_INTERVAL:
 
data: w_date like sy-datum.
data: new_date like sy-datum.
CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL' 
     EXPORTING                           
          DATE      = w_date   
          DAYS      = 0                  
          MONTHS    = 3                  
          SIGNUM    = '-'                
          YEARS     = 0                  
     IMPORTING                           
          CALC_DATE = new_date   
     EXCEPTIONS                          
          OTHERS    = 1.        


* new_date has a value 3 months of the past.

Regards,

Santosh

Re: regarding date

former_member508729 — Thu, 18 Jan 2007 06:35:22 GMT

Hi,

Just try to use this FM HRWPC_BL_DATES_MONTH_INTERVAL

here you have to give date and number of month before given date and number of month ahead of given date.

this FM returns the dates subtracting from given date.

Regards

Ashutosh

Reward points if helpful

Re: regarding date

jayanthi_jayaraman — Thu, 18 Jan 2007 06:35:26 GMT

Hi,

Use ccm_go_back_months

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:35:40 GMT

Hi,

Use MONTH_PLUS_DETERMINE, and pass -13 for previous date.

+13 for future date.

Regards

Subramanian

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:38:45 GMT

Hi,

Use this

CALL FUNCTION 'CALCULATE_DATE'

EXPORTING

DAYS = '0'

MONTHS = '-13'

START_DATE = SY-DATUM

IMPORTING

RESULT_DATE = lv_date.

write lv_date.

Rgds,

Prakash

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:38:49 GMT

Hi,

Use this FM

/BEV3/CHCALCULATE_DATE

DATE 12.12.2005

Pass the values like

DAYS 00

MONTHS 13

SIGNUM -

YEARS 0000

KZ_INCL X

Output

CALC_DATE 11.11.2004

Hope this will help u.

Thanks

Shiva

Re: regarding date

Former Member — Thu, 18 Jan 2007 06:47:27 GMT

Hi,

Use the FM:

<b>CALCULATE_DATE</b>

Increase/decrease DATE by a specific number of Days/Months

Hope it helps.

Reward if helpful.

Regards,

Sipra

Re: regarding date

Former Member — Thu, 18 Jan 2007 07:09:24 GMT

hi,

Use the function module .

CALL FUNCTION 'CALCULATE_DATE'

EXPORTING

days = '0'

months = '-13'

start_date = '20061123' " give your start date

IMPORTING

result_date = X.

hope this helps .