topic function module to conver date to internal format in Application Development and Automation Discussions

function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 06:43:03 GMT

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.

Re: function module to conver date to internal format

sreeramkumar_madisetty — Fri, 23 Feb 2007 06:44:42 GMT

Use the FM:

CONVERT_DATE_TO_INTERN_FORMAT

Regards,

kumar

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 06:45:08 GMT

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

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 06:46:12 GMT

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

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 06:57:00 GMT

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

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 07:02:03 GMT

DATE_CONV_EXT_TO_INT is easy n good

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 08:17:18 GMT

Hi ,

Try FM <b>CONVERT_DATE_TO_INTERNAL</b>

reward if useful.

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 08:21:11 GMT

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

Re: function module to conver date to internal format

Former Member — Fri, 23 Feb 2007 09:39:21 GMT

Use the following function module

'CONVERT_DATE_TO_INTERNAL'

'CONVERT_DATE_TO_EXTERNAL'

Hope this helps.

Regds,

Seema