How To Fix ALSMEX035 - Invalid symbol in date field

ALSMEX035 - Overview

• Message type: E = Error

• Message class: ALSMEX - Message Class for Legacy Data Transfer

• Message number: 035

• Message text: Invalid symbol in date field

What causes this issue?

The '&v1&' field in the Excel input file contains an invalid symbol.
The field is assigned to a date field in the asset master record.
Therefore it is only permitted to contain numbers and these symbols:
slash (/), period (.).
The value of the field is '&v2&'.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Change the contents of the field in the input file. Or, if the '&v1&'
field was incorrectly assigned to a date field, create a new field
assignment.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

ALSMEX035 - Details

• The SAP error message ALSMEX035: Invalid symbol in date field typically occurs when there is an issue with the date format or the input provided in a date field during data upload or processing, particularly when using the LSMW (Legacy System Migration Workbench) tool.
  
  Cause:
  
  Incorrect Date Format: The date entered does not match the expected format defined in the SAP system. For example, if the system expects a date in the format YYYY-MM-DD and the input is in DD/MM/YYYY, this error will occur.
  Invalid Characters: The date field may contain invalid characters or symbols that are not recognized as part of a valid date.
  Localization Issues: Different countries have different date formats, and if the system is set to a specific locale, it may not accept dates formatted in another locale.
  Data Source Issues: If the data is being imported from an external source, the data might not be cleaned or formatted correctly before