topic Re: Format String as Date, in Application Development and Automation Discussions

Format String as Date,

Yasin — Sat, 13 Apr 2019 09:29:23 GMT

Hi,

am using

CONCATENATE LINES OF I_TAB_DATES INTO TEMP_STR SEPARATED BY ', '

to join multi dates into one string to display in my report in one line. but am loosing the date format
is there any way to keep the date format !?

Thanks

Re: Format String as Date,

matt — Sat, 13 Apr 2019 09:47:51 GMT

You're not losing the date format, I was never there.

Dates are stored internally as YYYYMMDD.

If you want to put them into a non-date data type, like a string, formatted, you have to use WRITE.

Re: Format String as Date,

Yasin — Sat, 13 Apr 2019 10:19:41 GMT

Hi Mathew

Thanks for the clarification.

i cannot use Write since i want to show the final result in ALV Grid,

is there any other way?

Regards

Re: Format String as Date,

Yasin — Sat, 13 Apr 2019 10:31:24 GMT

Thank Mathew

i was able to do it base on your advise.

WRITE V_DATE TO TEMP_STR.

Appreciate.

Re: Format String as Date,

matt — Sat, 13 Apr 2019 12:45:41 GMT

Amazing what happens when you read the documentation. 😉

Re: Format String as Date,

developerone — Sat, 13 Apr 2019 15:28:35 GMT

You need to get a little creative with offset and concatenate. There are a lot of threads in the forum about string to date conversion. Here is one of them.