topic Re: Date Formatting Error in Application Development and Automation Discussions

Date Formatting Error

Former Member — Tue, 10 Jul 2007 17:33:33 GMT

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

ztable it is storing like this,

crdate Efdate

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

Can you please help me how to fix this.

Thanks,

Veni.

Re: Date Formatting Error

RichHeilman — Tue, 10 Jul 2007 17:36:34 GMT

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

Re: Date Formatting Error

Former Member — Tue, 10 Jul 2007 17:37:02 GMT

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.

Re: Date Formatting Error

Former Member — Tue, 10 Jul 2007 17:51:43 GMT

Thank you Rich and Mg.

Regards,

Veni.