Symptom
You are not able to upload Appointments via the Excel Upload due to the following error:
The value "of the field 'End Date Time' is invalid.
The value "of the field 'Start Date Time' is invalid.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Account Management work center.
- Select the Activities view.
- Click on the New button and select the option Activities from excel file.
- Select the New Appointment Activities excel file and download it.
- Fill in the required fields.
- Logon to the Excel add-in.
- Enter the respective system details, user and password.
- Click on Save the data to.
- The following error occurs:
The value "of the field 'End Date Time' is invalid.
The value "of the field 'Start Date Time' is invalid.
Cause
- No value is maintained in the column Start Time and End Time.
- The value maintained in the column Start Time and End Time is not a valid value. The time format should be passed in a 24h format. E.g. for 10 AM it should be entered as 10:00:00 and for 1pm it should be entered as 13:00:00
Please note that the entries are passed in UTC time zone.
Resolution
Enter valid values in the column Start Time and End Time.
Keywords
Time; Start; End; valid; Appointment; Activity; Activities; Excel; Upload; Add-In , KBA , SRD-CRM-ACT , Activities , Problem
Product
SAP Business ByDesign 2008