topic Re: Excel Date Format in Application Development and Automation Discussions

Excel Date Format

Former Member — Tue, 20 Mar 2007 16:25:48 GMT

Hi,

I have the invoice date comming in the excel sheet as - '071124 yymmdd'. Can we convert this to mmddyyyy format by any excel date format settings.

Please help me.

Thanks

Veni.

Re: Excel Date Format

Former Member — Tue, 20 Mar 2007 16:31:32 GMT

Hi!

I don't know exactly what is your problem.

In excel you can convert the cell formats. Right click on the cell, then choose Cell properties. In the popup window set the Date format, and then pick one of the given formats.

Regards

Tamá

Re: Excel Date Format

Former Member — Tue, 20 Mar 2007 16:40:50 GMT

Hi,

I need to upload a text file to the program, in that I have Invoice date column that is comming in the excel sheet as - '071124 yymmdd'. Can we convert this to mmddyyyy format by any excel date format settings.

Inv num Inv Date

71182264 071124

71183727 071017

71186064 060719

71186065 060719

71186201 060719

Please help me.

Thanks

Veni.

Re: Excel Date Format

rajasekhar_matukumalli3 — Tue, 20 Mar 2007 16:51:35 GMT

Hi Veni,

After reading the data to the internal table, loop through the internal table and pass your date to the function moduel "CONVERT_DATE_TO_INTERNAL". This will give you the date in SAP format (YYYYMMDD).

Hope this solved your problem

Enjoy SAP and reward points if useful.

Rajasekhar