How to convert the date from 00.00.0000 to 00/00/0000

[Former Member]

Hi,

I am uploading  excel sheet.the date is in format 00/00/0000.But when i m uploading the xl file i m getting the error

Enter a valid date (for example, 21.09.2012)

.

Ply anybody help me out??

Regards.

Moderator message: frequently discussed, please search for information before posting.

Message was edited by: Thomas Zloch

[amol_samte]

Hi devi,

Check in debugger...date shoud be like datum format..concatinate as per datum...that might work,

Regards,

Amol

[Former Member]

u can use the statement.

REPLACE ALL OCCURRENCES OF '.' in v_date WITH '/' IGNORING CASE .

[Former Member]

hello,

please check your personal settings using SU01. How the date is mainatined there ?

Also SAP will take care of the date pass it to a datum type field which is something like this YYYYDDMM. In excel just select the date column and replace the '/' with blank or else you would need to write extra logic after you upload the file.

best regards,

swanand

[TuncayKaraca]

Hi Bakyadevi,

DD.MM.YYYY format (21.09.2012) is user's format for display purpose.  (SAP's internal format as you know is YYYYMMDD)

Once you get a date from a file, you need to know what format is used, then you need to convert it to user format by using string functions.