topic Re: conver date format in Application Development and Automation Discussions

conver date format

Former Member — Thu, 28 Sep 2006 07:46:27 GMT

hi all,

how to convert the date format for ex.

i have date yyyymmdd but i want to change to ddmmyyyy . hw can possible.

regards.

amjad

Re: conver date format

Former Member — Thu, 28 Sep 2006 07:51:29 GMT

Hi,

Use Function module Convert_date_format for this. This will work.

Re: conver date format

Former Member — Thu, 28 Sep 2006 07:52:03 GMT

Refer these threads:

Try searching the forum with 'date conversion' and you should get many more such examples.

Sudha

Re: conver date format

Former Member — Thu, 28 Sep 2006 07:52:52 GMT

Hi,

use the Function module <b>CONVERT_DATE_TO_EXTERNAL</b>

See the below link for more Date converstions:-

http://www.sap-basis-abap.com/sapab015.htm

Regards

Sudheer

Re: conver date format

shishupalreddy — Thu, 28 Sep 2006 07:55:41 GMT

Hi ,

USE THE FOLLOWING CODE to convert the date into ur required format.

DATA : date1(10) value sy-datum.

data: l_f_date(10).

write date1 to l_f_date dd/mm/yyyy.

hope it will solve your problem .

regards,

Re: conver date format

Former Member — Thu, 28 Sep 2006 07:55:49 GMT

USE FOLLOWING EXAMPLE

data : ld_date(10) type c.

write irecord-datab to ld_date dd/mm/yyyy.

data : ld_date1(10) type c.

write irecord-datub to ld_date1 dd/mm/yyyy.

IT WILL WORK .

THANKS

Maheedhar.T

Re: conver date format

Former Member — Thu, 28 Sep 2006 08:08:31 GMT

Hello,

Do not use any function module or some "concatenate" statement. I guess you want to switch from system date format to european format (ddmmyyyy).

Date and amount format are defined in IMG for all country, then if a user wants a specific format, this is set up in his own user settings. Do not re-create what SAP already did.

If you want to determine format based on a country, process as below:

set country <country code>

write <my_variable_date> to <my_variable_string>

write:/001 <my_variable_date>

If you want to use user own settings then process as below:

write <my_variable_date> to <my_variable_string>

write:/001 <my_variable_date>

As you can see statement "set country <country code>" is used to get data from table t005x (where country code format are defined) otherwise if you don't use it, the "write" statement will use format that has been defined in t.code SU3 (user specific)

Let me know if you need additional informations,

Mehdi

Re: conver date format

Former Member — Thu, 28 Sep 2006 08:23:42 GMT

U can either use the given fm by others or simply use a write statement.

WRITE ldate to lfdate ddmmyyyy.

ldate -> variable containing the date in yyyymmdd format

lfdate -> output with date in ddmmyyyy format.

Regards

Anurag

Re: conver date format

Former Member — Tue, 27 Sep 2011 13:50:16 GMT

thx