Symptom
- When cases are exported to an Excel file from the Case Worklist, the date and time fields in the downloaded file are displayed in UTC.
- The time zone maintained in the user profile or system settings may be different, for example, (IST). However, the exported Excel file still displays the time values in UTC.
Environment
SAP Sales and Service Cloud Version 2
Reproducing the Issue
- Log on to system.
- Go to Cases.
- Open the Case Worklist.
- Select the required cases.
- Use the Import option to download the case data.
- Open the downloaded Excel file.
- Check the date and time fields.
The time values are displayed in UTC, regardless of the time zone maintained in the user profile or system settings.
Cause
- This is the expected system behavior.
- The date and time fields in the exported Excel file are provided in UTC, regardless of the time zone maintained in the user's profile or system settings.
Resolution
The time fields in the exported Excel file are formatted and provided in UTC based on the current system configuration.
Keywords
Time zone, UTC, Excel, Case, Case Worklist, Export, Download, Date and Time , KBA , CEC-CRM-CAS , Case Management for SAP Sales/Service Cloud , Problem
Product
SAP Sales Cloud and SAP Service Cloud Version 2 1.0
SAP Knowledge Base Article - Public