topic Re: How to convert string format ? in Application Development and Automation Discussions

How to convert string format ?

1190_5939_439 — Thu, 21 Oct 2021 12:24:20 GMT

Hi Experts

The code is following


 erdat LIKE vbrp-erdat, 
 erzet LIKE vbrk-erzet, 

 send_date  type string,

 CONCATENATE gw_vbrk-erdat  gw_vbrk-erzet  into gw_send-send_date.

Now the string format is follwing
20211006094324

I hope I get following string format.
2021-10-06 10:00:00
Can you help me ? Thanks.

Re: How to convert string format ?

sergey_muratov — Thu, 21 Oct 2021 12:53:47 GMT

Hi!

Take a look at WRITE statement

Re: How to convert string format ?

FredericGirod — Thu, 21 Oct 2021 13:15:33 GMT

my_field = |{ my_date DATE = USER }{ my_time TIME=USER }|

something like that ?

Re: How to convert string format ?

retired_member — Thu, 21 Oct 2021 16:29:44 GMT

String templates are the way to go ...

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abenstring_templates.htm

Re: How to convert string format ?

Sandra_Rossi — Sat, 23 Oct 2021 04:51:16 GMT

It seems you frequently write blog posts in your own Web site to explain what you finally did, and you just post a link to refer to it. You did it repeatedly in your recent questions, I think you shouldn't, as per Engagement Rules "unacceptable content":

Content or comments primarily designed to drive traffic to, increase the search rankings of, generating revenue from, or gain any other personal benefit from a non-SAP site, product, or service.

Instead, include your answer here. Anyway, note that the answer in your blog post is using a non-released function module, and that's not the way to do it in SAP. Frederic answer is the way to do it, with String Templates (as per Horst link), by taking the user's date and time formats. Or you may choose specific date formats so that to always use the YYYY-MM-DD format (like COUNTRY or XSD option).

Re: How to convert string format ?

Sandra_Rossi — Sat, 23 Oct 2021 04:54:26 GMT

Instead of DATE = USER, your String Template could use XSD = YES to always format in YYYY-MM-DD format, and it could be the same for the time format to avoid 12-hours formats.

DATA(date) = CONV d( '20211023' ).
DATA(time) = CONV t( '114800' ).
DATA(my_field) = |{ date XSD = YES } { time XSD = YES }|.
ASSERT my_field = '2021-10-23 11:48:00'.

Re: How to convert string format ?

former_member773178 — Sat, 23 Oct 2021 15:15:24 GMT

useful information.

Re: How to convert string format ?

FredericGirod — Mon, 25 Oct 2021 08:30:29 GMT

nice trick sandra.rossi