Excel Date Format

[Former Member]

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.

[Former Member]

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á

[Former Member]

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.

[rajasekhar_matukumalli3]

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