Date Formatting Error

[Former Member]

Hi,

I am getting data from excel file and updating it to a custom table. I have date fields in it. When uploading it is looking fine, but in the Ztable it is storing differently.

I have a module pool for that table to change and delete the records, When I try to change or delete the record it is giving the error saying invalid date format.

Crdate and Efdate are defined in the Ztable as DATS and length 8.

In the excel it is like this,

crdate Efdate

7/2/2007 7/15/2007

7/2/2007 7/15/2007

ztable it is storing like this,

crdate Efdate

20/07/7/2/ /2/00/7/15

20/07/7/2/ /2/00/7/15

Can you please help me how to fix this.

Thanks,

Veni.

[RichHeilman]

When bringing from excel and then moving into ztable, you must convert the date fields into SAP internal format, which is YYYYMMDD There are a number of ways to achieve this. You can use the function module CONVERT_DATE_TO_INTERNAL , then move this formatted value into your ztable.

Regards,

Rich Heilman

[Former Member]

Thank you Rich and Mg.

Regards,

Veni.

[Former Member]

once you get the data from the excel before storing in table, try to change the format of the dates from mm/dd/yyyy to YYYYMMDD and then update it.