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

How to format a date string?

Former Member — Fri, 25 Jul 2008 13:37:45 GMT

Hi guys!

How can i format a date which comes from the database in format eg '20080131' into a nice display format?

in particular i want to display my date like 'DD.MM.YYYY'

thanks

Former Member — Fri, 25 Jul 2008 13:40:04 GMT

THe simplest way would be to use Offsets and Concatenate statement

For eg.

v_date = '20080723'.

something like:

CONCATENATE v_date6(2) '.' v_date4(2) '.' v_date+0(4) INTO v_new_date

Former Member — Fri, 25 Jul 2008 13:40:07 GMT

hi,

Use EDIT MASK and the type to get the Functionality.

data date like sy-datum.
date = <your date>.

write:/ date using EDIT MASK '__/__/____'.

Regards

Sumit Agarwal

Former Member — Fri, 25 Jul 2008 13:40:39 GMT

thomas,

if date = 20080131.

than concatenate date+6(2) '.' date+4(2) '.' date+0(4) '.' into newdate.

Amit.