‎2007 Feb 21 6:27 AM
Hi Friends,
Can anybody tell me one fuction module which gives the date in particular format for ex :- 26th January 2007 ?
Thx in Adv.
Bapi bobby
‎2007 Feb 21 6:31 AM
check FM
CONVERSION_EXIT_IDATE_OUTPUT
after this u can put ur own logic .
regards
Prabhu
‎2007 Feb 21 6:31 AM
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-LTX YEAR INTO FINAL SEPARATED BY SPACE.
WRITE: FINAL.
‎2007 Feb 21 6:33 AM
Hi,
Use the Function moduel MONTH_NAMES_GET to get the Month names.
and concatiante this with the Day and Year to get the format
Regards
Sudheer
‎2007 Feb 21 6:35 AM
hi,
Few examples :
1)
data: gd_date(8). "field to store output date
Converts date from 20010901 to 01SEP2001
gd_date = sy-datum.
CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'
EXPORTING
input = gd_date
IMPORTING
OUTPUT = gd_date.
2)
data: gd_date(8). "field to store output date
Converts SAP date from 20010901 to 01092001
gd_date(2) = sy-datum+6(2).
gd_date2(2) = sy-datum4(2).
gd_date+4(4) = sy-datum(4).
3)
data: gd_date(10). "field to store output date
Converts SAP date from 20020901 to 01.09.2002
write sy-datum to gd_date dd/mm/yyyy.
Converts SAP date from 20020901 to 01.09.02
write sy-datum to gd_date dd/mm/yy.
Regards,
Bijal
‎2007 Feb 21 6:37 AM
Run the below code to convert 01/24/2007 to 24th january 2007
REPORT ZEX33 .
parameter : p_date like sy-datum.
DATA: month(9),
year(4),
date(2),
ch(2).
data : return_date(20).
CASE p_date+4(2).
WHEN '01'.
month = 'January'.
WHEN '02'.
month = 'February'.
WHEN '03'.
month = 'March'.
WHEN '04'.
month = 'April'.
WHEN '05'.
month = 'May'.
WHEN '06'.
month = 'June'.
WHEN '07'.
month = 'July'.
WHEN '08'.
month = 'August'.
WHEN '09'.
month = 'September'.
WHEN '10'.
month = 'October'.
WHEN '11'.
month = 'November'.
WHEN '12'.
month = 'December'.
WHEN OTHERS.
ENDCASE.
WRITE p_date+0(4) TO year.
WRITE p_date+6(2) TO date.
case date.
when '01'. ch = 'st'.
when '21'. ch = 'st'.
when '31'. ch = 'st'.
when '02'. ch = 'nd'.
when '22'. ch = 'nd'.
when '03'. ch = 'rd'.
when '23'. ch = 'rd'.
when others. ch = 'th'.
endcase.
CONCATENATE date ch month year INTO return_date.
SEPARATED BY space.
CONDENSE return_date.
write : / return_date.
‎2007 Feb 21 6:39 AM
Currently my date is getting printed in format 05262005.
I want the output as 26 May, 2005.
I have tried using Set date mask option but it is not picking up in the output.
Code:
This code yields as 12 march 2006.
DATA: ZTEMP(9).
CLEAR: ZTEMP, ZDD, ZMMM, ZYYYY.
CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'
EXPORTING
INPUT = IS_DLV_DELNOTE-HD_GEN-CREA_DATE
IMPORTING
OUTPUT = ZTEMP.
ZDD = ZTEMP+3(2).
ZMMM = ZTEMP+0(3).
ZYYYY = ZTEMP+5(4).
http://www.sap-img.com/abap/abap-program-output-of-date-format.htm
‎2007 Feb 21 6:42 AM
hi,
DATA: DATE_CHAR(20).
DATA: DATE TYPE SY-DATUM.
DATA: MONTH_NAME LIKE T247-LTX.
DATE = SY-DATUM.
SELECT SINGLE LTX FROM T247
INTO MONTH_NAME
WHERE SPRAS = SY-LANGU
AND MNR = SY-DATUM+4(2).
CONCATENATE SY-DATUM+6(2) MONTH_NAME SY-DATUM(4)
INTO DATE_CHAR SEPARATED BY SPACE.
WRITE: / DATE_CHAR.or use this FM
CACS_DATE_GET_YEAR_MONTH : To get the number of the month
MONTH_NAMES_GET: To get month description
Regards
Anver
‎2007 Feb 21 6:45 AM
Hi,
<b>Use the followinf FM:
CONVERT_DATE_TO_EXTERNAL</b> Converts date from system storage format to users specified display format
Hope this helps.
reward if helpful.
Regards,
Sipra