topic Re: remove '.' from date in Application Development and Automation Discussions

remove '.' from date

Former Member — Tue, 23 Sep 2008 07:20:31 GMT

hi,

i am passing a date field in my program as 23.09.2008, but i want to remove the '.' before process it. can any one advice what is the code to remove '.'? i believe there is but i already forgotten of it. thanks

Re: remove '.' from date

Former Member — Tue, 23 Sep 2008 07:21:20 GMT

hi...

use replace

regards

vivek

Re: remove '.' from date

rainer_hbenthal — Tue, 23 Sep 2008 07:24:06 GMT


REPLACE all occurences of '.' in date_field with ''.

Re: remove '.' from date

Former Member — Tue, 23 Sep 2008 07:24:40 GMT


DATA: w_var(10) TYPE c.
w_var = '31.12.2008'.

REPLACE ALL OCCURRENCES OF '.' in w_var WITH '' .
WRITE / w_var.

Re: remove '.' from date

Former Member — Tue, 23 Sep 2008 07:28:10 GMT

Hi ben,

Replace will only remove .(dots) and give the date as 23092008 but the internal date format is 20080923.

So use the FM CONVERT_DATE_TO_INTERNAL to convert a date to internal format.

Revert Back if you have doubts.

Regards

Karthik d

Re: remove '.' from date

bpawanchand — Tue, 23 Sep 2008 07:31:11 GMT

DATA :
   w_d TYPE d,
   w_d1 TYPE sy-datum.


w_d1 = sy-datum.

CONCATENATE w_d1+0(4) w_d1+4(2) w_d1+6(2) INTO w_d.

WRITE :
  / w_d.

Regards

Pavan

Re: remove '.' from date

Former Member — Tue, 23 Sep 2008 07:34:47 GMT

Hi,

Try like this:

data: fld1(12) type c,

fld2(12) type c,

fld3(2) type c,

fld4(2) type c,

fld5(4) type c.

fld1 = '23.09.2008'.

fld3 = fld1+0(2).

fld4 = fld1+3(2).

fld5 = fld1+6(4).

concatenate fld3 fld4 fld5 into fld2.

write: / fld1,

/ fld2.

Regards,

Bhaskar

Re: remove '.' from date

Former Member — Tue, 23 Sep 2008 07:50:39 GMT

believe there is but i already forgotten of it

But SDN database is still Active and Up so you need to just search nothing else