topic Re: DATE CONVERSION in Application Development and Automation Discussions

DATE CONVERSION

Former Member — Mon, 31 Dec 2007 13:38:47 GMT

Hi gurus,

here is one problem with date.in my excel sheet i had a date like (19-june-99).Now im uploading data from excel to internal table.So when im triying to upload to sap .It is not accepting.it gives error message like uploading date should be (19.06.99) in this format.But im not changing in excel that is not possible.Pls help me out on this issue.

thanks in advance best solution will be revarded

Re: DATE CONVERSION

Former Member — Mon, 31 Dec 2007 13:50:22 GMT

if changing date in excel is not an option then you must convert the date during upload - u need to upload the data then use some conversion logic on the date before saving to the internal table.

Re: DATE CONVERSION

Former Member — Mon, 31 Dec 2007 14:48:31 GMT

use this code to convert excel date...

DATA : month(10), mm(2), dd(2), yy(2).

DATA : exel_date(16) VALUE '19-June-99'.

DATA : date(8).

SPLIT exel_date AT '-' INTO dd month yy.

SELECT SINGLE mnr INTO mm FROM t247 WHERE ltx = month AND spras = sy-langu.

CONCATENATE dd mm yy INTO date SEPARATED BY '-'.

WRITE 😕 date.