convert date to timestamp

[Former Member]

hi,

I'm converting an spread sheet to internal table using FM 'ALSM .........' my problem is I'm getting date from the excell sheet but before storing it into internal table i want to convert the date into timestamp.

regards,

santosh

[Former Member]

hi,

I'm converting an spread sheet to internal table using FM 'ALSM .........' my problem is I'm getting date from the excell sheet but before storing it into internal table i want to convert the date into timestamp.

regards,

santosh

[Former Member]

hi,

Try this FM.

RKE_TIMESTAMP_CONVERT_INPUT – Converts display to TIMESTAMP fields

\[removed by moderator\]

Edited by: Jan Stallkamp on Jul 24, 2008 12:41 PM

[Former Member]

Hi,

Please use FM CIF_GEN3_CONVERT_DATETIME.

Thanks,

Sriram Ponna.

[Former Member]

hi,

FRE_MASTER_OUT F&R CON R/3 Master Data

Functions

FRE_CONVERT_DATE_TO_TIMESTMP Convert Date to Timestamp

FRE_ORDER_IN F&R CON R/3 - Purchasing

Functions

FRE_CONVERT_DATE_2_TIMESTAMP Converts Date into Timestamp (15)

FRE_CONVERT_TIMESTAMP_2_DATE Converts Timestamp (15) into Date

Regards,

Brown.

[Former Member]

Please see if the "CONVERT" operator does what you want. There is a pretty good help page on it. Here is a small extract from it.

CONVERT DATE

Syntax

CONVERT DATE dat [TIME tim [DAYLIGHT SAVING TIME dst]]

INTO TIME STAMP time_stamp TIME ZONE tz.

[Former Member]

Hi Santosh,

also check this from other thread

REPORT YCHATEST MESSAGE-ID ZZ .

data: str type string.

concatenate sy-datum sy-uzeit ',' '0000000' into str.

write:/ str.

[Former Member]

bjbhb