topic Re: Date calculaion in Application Development and Automation Discussions

Date calculaion

Former Member — Tue, 20 May 2008 13:25:23 GMT

Hi All,

i have one field(char) which have date in format as dd.mm.yyyy.

now i want to add 5 dayes in that field.

i can do it by using concatenate and split. but i want to do it by FM because i need same format as dd.mm.yyyy after calculation.

is there any FM to convert char into date?

Amit.

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:27:45 GMT

Why dont you define you field of type sydatum, do all the calculations and then convert it to you required format. It is easier to deal with sydatum type variables

Re: Date calculaion

former_member435013 — Tue, 20 May 2008 13:30:46 GMT

Hi,

use CONVERT_DATE_TO_INTERNAL.

Regards

Walter Habich

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:32:28 GMT

Use FMS

"CONVERT_DATE_TO_INTERNAL" or

"CONVERT_DATE_TO_EXTERNAL"

Regards,

Santosh

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:33:41 GMT

'RP_CALC_DATE_IN_INTERVAL'

HR_SEN_CALE_DAYS_DATE

CONVERSION_EXIT_SDATE_OUTPUT

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:40:06 GMT

Hi All,

thanks for your replies.

But i have date value in char field.

i need to convert it into as date type.

Amit.

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:42:14 GMT

When all else fails.. Use a bigger hammer.


DATA: my_cdate(10)   TYPE c VALUE '31.05.2008',
      my_ddate       TYPE d.

write:/ my_cdate.

my_ddate+0(4) = my_cdate+6(4). "YYYY
my_ddate+6(2) = my_cdate+0(2). "DD
my_ddate+4(2) = my_cdate+3(2). "MM

my_ddate = my_ddate + 5.

concatenate my_ddate+6(2)
            my_ddate+4(2)
            my_ddate+0(4) into my_cdate
            separated by '.'.

write:/ my_cdate.

Output


31.05.2008         
05.06.2008

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:56:28 GMT

Well Paul I did already exactly same as you suggest.

Thank you All.

Amit.

Re: Date calculaion

Former Member — Tue, 20 May 2008 13:59:20 GMT

Hi Jony,

Do as follow...

data : dt_chr(10) TYPE c VALUE '20.05.2008'.    

data : P_DATE TYPE SY-DATUM.

DATA : pa_end TYPE sy-datum.

data: DD(2) TYPE C,
MM(2) TYPE C,
YY(4) TYPE C,
temp_DATE(8) TYPE C.

*DATE1 = SY-DATUM.

DD = dt_chr+0(2).
MM = dt_chr+3(2).
YY = dt_chr+6(4).

CONCATENATE YY mm dd INTO temp_DATE.

p_date = temp_date.

CALL FUNCTION 'RP_CALC_DATE_IN_INTERVAL'
EXPORTING
date = p_date
days = '05'
months = '00'
signum = '+'
years = '00'
IMPORTING
calc_date = pa_end.

WRITE : pa_end. " Required Date

again use concatenate stmt to make it in dd.mm.yyyy format...

it will give accurate result..

Hope it will solve your problem

Reward points if useful...

Thanks & Regards

ilesh 24x7