topic Re: DATE FORMAT in Application Development and Automation Discussions

DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:43:30 GMT

Hi Experts,

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

Please help me how to display the date as above format

Thanks & Regards,

Divya

Re: DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:47:32 GMT

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

Re: DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:47:56 GMT

u can use fm..

CONVERSION_EXIT_IDATE_OUTPUT-->

using this fm u get in date format ddmmmyyyy.

now u easly change it to ddmmmyy

there is logic just copy and paste and use it...

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.

Re: DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:53:33 GMT

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

Re: DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:55:38 GMT

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.

Re: DATE FORMAT

Former Member — Fri, 22 Sep 2006 08:56:13 GMT

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