EXCEL日期轉成SAP日期

EXCEL日期格式：日.月.年(19.12.2010)

 

FORM data_convert USING p_value p_date.
  CLEAR: p_date.
  CALL FUNCTION 'CONVERT_DATE_INPUT'
    EXPORTING
      input                     = p_value
      plausibility_check        = 'X'
    IMPORTING
      output                    = p_date
    EXCEPTIONS
      plausibility_check_failed = 1
      wrong_format_in_input     = 2
      OTHERS                    = 3.
ENDFORM.   "--DATA_CONVERT