topic Re: date and time in Application Development and Automation Discussions

date and time

Former Member — Fri, 01 Dec 2006 17:09:26 GMT

i have declared the date and time fields as date(12) and time(15) in an internal table . The data is coming from a file with some comma separater then i am splitting the data based on comma and storing them in date and time fields internal table first and then update my custome table with the internal table . I have declared the fields in the custom table as dats and tims. The data in the internal table is fine but i cant update it properly to the custom table.I appreciate your immediate response.

Re: date and time

Former Member — Fri, 01 Dec 2006 17:14:42 GMT

Hi,

What is the date format stored in the file??

Thanks,

Naren

Re: date and time

RichHeilman — Fri, 01 Dec 2006 17:38:37 GMT

You need to convert the date and time in your file to the format YYYYMMDD and HHMMSS to store it in your custom table. This is how the date and time is stored in SAP, and you must convert your date and time to it.

Regards,

Rich Heilman

Re: date and time

Former Member — Fri, 01 Dec 2006 18:59:42 GMT

file data will be like 6/1/2006 or 10/1/2006 . I mean day and month length can be 1 or 2.

Re: date and time

Former Member — Fri, 01 Dec 2006 19:00:37 GMT

Rich,

how can i convert it to that format

Re: date and time

Former Member — Fri, 01 Dec 2006 19:02:07 GMT

Hi,

use the FM CONVERT_DATE_TO_INTERNAL

Check this example

DATA: v_date TYPE sydatum.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

date_external = '6/1/2006'

IMPORTING

date_internal = v_date

EXCEPTIONS

date_external_is_invalid = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

WRITE: / v_date.

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL'

EXPORTING

date_external = '10/1/2006'

IMPORTING

date_internal = v_date

EXCEPTIONS

date_external_is_invalid = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

WRITE: / v_date.

Thanks,

Naren