topic Date Conversion in Application Development and Automation Discussions

Date Conversion

Former Member — Wed, 16 Jul 2008 01:04:24 GMT

Hi all,

i have a flat file with a date field(YYYYMMDD),

how can i convert this into user defined format.

Regards

Hema

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 03:19:42 GMT

e.g. The write statement will convert the internal format into the user defined date format.

Either do a write / date_field.

Or write date_field to other_field.

Hope that helps,

Michael

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 03:24:36 GMT

Hi,

convert to Excel then u chage the formate whatever u want.

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 03:42:32 GMT

Hi,

Take the date from your flat file into an internal table along with all other fields and then Make use of FM CONVERT_DATE_TO_EXTERNAL .

This should solve your problem.

Pls reward if useful.

Regards,

lalit

Re: Date Conversion

abdul_hakim — Wed, 16 Jul 2008 03:45:03 GMT

use WRITE source TO target.

Cheers,

Hakim

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 04:41:26 GMT

Hello Hema,

The write statement will work for you.

write w_date1 to w_date2.

(where w_date2 is your required format.)

Regards

Indu.

Re: Date Conversion

former_member787646 — Wed, 16 Jul 2008 04:42:45 GMT

You can try the following ways and check.

1. Write:/ date1 DD/MM/YYYY.

2. Using Concatenate Statement you can achieve the desired format.

Hope this would help you.

Murthy

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 05:01:06 GMT

Use

WRITE Date_variable TO Date_variable

USING EDIT MASK '__/__/____'.

"USING EDIT MASK ........... use the format desired.

Re: Date Conversion

Former Member — Wed, 16 Jul 2008 05:01:44 GMT

Hi Hema.

I would like to suggest a few,

You can try---> using Edit mask statement.

Concatenation date with offsets.

use: source to target conversion DD/MM/YYYY or vice versa.

Try using function modules------->

DATE_CONV_EXT_TO_INT - Conversion of dates to SAP internal format (Check sy-subrc)

PDOT_DATE_CONVERT Convert date (yyyymmdd >dd.mm.yyyy)

CONVERT_DATE_TO_INTERN_FORMAT Converts a date to internal format

CONVERT_DATE_TO_EXTERNAL Conversion: Internal to external date (like screen conversion)

CONVERT_DATE_TO_INTERNAL Conversion: External to internal date (like screen conversion)

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

Edited by: Harsh Dave on Jul 16, 2008 10:34 AM