Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

DATE FORMAT

Former Member
0 Likes
975

Hi Experts,

I am using field(AUSP-ATWRT) for displaying date in the format like <b>25MAR06</b>

Please help me how to display the date as above format

Thanks & Regards,

Divya

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
879

u can use fm..

<b>CONVERSION_EXIT_IDATE_OUTPUT</b>-->

using this fm u get in date format ddmmmyyyy.

now u easly change it to ddmmmyy

OR

<b>there is logic just copy and paste and use it</b>...

parameters: date like sy-datum.
data: begin of itab occurs 0,
SPRAS type SPRAS,
MNR LIKE T247-MNR,
KTX LIKE T247-KTX,
LTX LIKE T247-LTX,
end of itab.
DATA : month LIKE T247-MNR.
DATA: YEAR(4).
DATA: FINAL(18).
DATA: DAY(2).
DAY = DATE+6(2).
MONTH = DATE+4(2).
YEAR = DATE+0(4).
select SINGLE * from t247 into itab where mnr = month
AND SPRAS = 'E'.
APPEND ITAB.
CONCATENATE DAY ITAB-KTX YEAR+2(2) INTO FINAL SEPARATED BY ''.
WRITE: FINAL.

5 REPLIES 5
Read only

Former Member
0 Likes
879

data: date type sy-datum,
      text(20).
 date = sy-datum.
 CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' 
 EXPORTING  
  INPUT         = date
 IMPORTING  
 OUTPUT        = text.

Message was edited by: Srikanth Kidambi

Read only

Former Member
0 Likes
880

u can use fm..

<b>CONVERSION_EXIT_IDATE_OUTPUT</b>-->

using this fm u get in date format ddmmmyyyy.

now u easly change it to ddmmmyy

OR

<b>there is logic just copy and paste and use it</b>...

parameters: date like sy-datum.
data: begin of itab occurs 0,
SPRAS type SPRAS,
MNR LIKE T247-MNR,
KTX LIKE T247-KTX,
LTX LIKE T247-LTX,
end of itab.
DATA : month LIKE T247-MNR.
DATA: YEAR(4).
DATA: FINAL(18).
DATA: DAY(2).
DAY = DATE+6(2).
MONTH = DATE+4(2).
YEAR = DATE+0(4).
select SINGLE * from t247 into itab where mnr = month
AND SPRAS = 'E'.
APPEND ITAB.
CONCATENATE DAY ITAB-KTX YEAR+2(2) INTO FINAL SEPARATED BY ''.
WRITE: FINAL.

Read only

0 Likes
879

hi,

Use the FM CONVERSION_EXIT_SDATE_OUTPUT.

PROGRAM  ZRICHA_003.
DATA : V_DATE TYPE SY-DATUM.
DATA : V_IDATE(20) TYPE C.
data : v_char(20) type c.

START-OF-SELECTION.
  v_date = sy-datum.
  write : v_date.

  CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
    EXPORTING
      INPUT         = v_date
   IMPORTING
     OUTPUT        = v_idate.
            .
  write : v_idate.
"check the user settings in USR01 and display using write
"in my case v_idate = SEP/22/2006
  concatenate  v_idate+4(2) v_idate+0(3) v_idate+9(2) into v_char.
  write : v_char.

The outout comes as 22SEP06

Regards,

Richa

Message was edited by: Richa Singh

Read only

Former Member
0 Likes
879

Hi

PARAMETERS: P_DATE LIKE SY-DATUM.

DATA: T_MONTHS LIKE STANDARD TABLE OF T247 WITH HEADER LINE.

DATA: DATE LIKE AUSP-ATWRT.

CALL FUNCTION 'MONTH_NAMES_GET'

TABLES

MONTH_NAMES = T_MONTHS.

READ TABLE T_MONTHS WITH KEY MNR = P_DATE+4(2).

DATE(2) = P_DATE+6(2).

DATE+2(3) = T_MONTHS-KTX.

DATE5(2) = P_DATE2(2).

WRITE DATE.

Max

Read only

Former Member
0 Likes
879

Hi divya,

use this function mudule.

CONVERSION_EXIT_IDATE_OUTPUT

input sholud be in the format 20060922.if u give this date format as input it will give 22sep2006 as output.

Hope this will help you.