topic Re: Date Format. in Application Development and Automation Discussions

Date Format.

Former Member — Sat, 17 Jun 2006 20:13:32 GMT

Hi Friends,

I need to change date format from YYYYMMDD to MM/DD/YY format in the internal table, because i need to send ths internal table to an external non SAP system.

Shejal.

Re: Date Format.

suresh_datti — Sat, 17 Jun 2006 20:15:12 GMT

write itab-date to itab-date mm/dd/yyyy.

concatenate itab-date4(2) '/' itab-date6(2) '/'

itab-date+2(2) into itab-date.

~Suresh

Re: Date Format.

Former Member — Sun, 18 Jun 2006 03:49:42 GMT

Hi Shejal,

There is a function module which takes the date as YYYYMMDD and output it as DD/MM/YYYY.

Please check this standard FM.

FM Name : PERIOD_AND_DATE_CONVERT_OUTPUT

Purpose : Conversion of a date with period

specification with output.

Usage :

Import : YYYYMMDD (Internal Date), Language, Country,

Internal Period;

Export : country specific date|period string

(External Date), External Period,

External Period Text.

Int.Period Ext.Period Ext.Date, e.g. Ext.Per.Text

1 D MM/DD/YYYY

2 W WW/YYYY Week

3 M MM/YYYY Month

4 P ? space

5 K ? space Calndr

Hope this will help u in some way.

Re: Date Format.

Clemenss — Sun, 18 Jun 2006 07:59:21 GMT

make it simple:

Use ABAP statement write with formatting option for date field, see also

http://help.sap.com/saphelp_47x200/helpdata/en/9f/70bed8fe1211d2b92f0000e8353423/frameset.htm

ABAP Programming (BC-ABA)->ABAP User Dialogs->Creating Lists->Creating Simple Lists with the WRITE Statement->Formatting Options

write sy-datum MM/DD/YYYY to <target>.

where target is your character-type output field.

Regards,

Clemens