function module to conver date to internal format

[Former Member]

Can anybody say what is the function module used to convert the format of the date which is taken from excel sheet to the sap format. If so pls tell me how to use that function module.

[sreeramkumar_madisetty]

Hi

Use the FM:

CONVERT_DATE_TO_INTERN_FORMAT

Regards,

kumar

[Former Member]

Hi,

Use the FM:

<b>DATE_CONV_EXT_TO_INT</b> - user formatted date is converted to system date

Hope this helps.

Reward if helpful.

Regards,

Sipra

[Former Member]

Hi

Use the functions modules CONVERT_DATE_TO_EXTERNAL or CONVERT_DATE_TO_INTERNAL to convert the date. When converting to external format, the date format from the user's user profile will be used. When converting to internal format, the result will be in YYYYMMDD format

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'
       EXPORTING
            DATE_EXTERNAL            = REC_DTL
       IMPORTING
            DATE_INTERNAL            = SPECTRO_ITAB-CAST_DATE
       EXCEPTIONS
            DATE_EXTERNAL_IS_INVALID = 1
            OTHERS                   = 2.

Regards

Sudheer

[Former Member]

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

[Former Member]

DATE_CONV_EXT_TO_INT is easy n good

[Former Member]

Hi ,

Try FM <b>CONVERT_DATE_TO_INTERNAL</b>

reward if useful.

[Former Member]

REPORT YCHATEST.
 
TYPE-POOLS : KCDE.
 
DATA : V_DATE1 TYPE KCDE_INTERN_VALUE,
       V_DATE2 TYPE KCDE_INTERN_VALUE.
 
V_DATE1 = '23/02/2007'.
 
CALL FUNCTION 'KCD_EXCEL_DATE_CONVERT'
  EXPORTING
    EXCEL_DATE  = V_DATE1
    DATE_FORMAT = 'TMJ'
  IMPORTING
    SAP_DATE    = V_DATE2
  EXCEPTIONS
    OTHERS      = 0.
WRITE : V_DATE2.

here in TMJ , T for day , M for Month and J for for year
if in the excel ur date format is MM/DD/YYYY , the give it as MTJ

[Former Member]

Hi

Use the following function module

'CONVERT_DATE_TO_INTERNAL'

'CONVERT_DATE_TO_EXTERNAL'

Hope this helps.

Regds,

Seema