search cancel

When exporting data with date format all of the dates come with PM

book

Article ID: 132471

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Whenever customer exports lists to excel with date components the date is not correct, all of them are marked as PM when they are not.

Environment

Xtraction 2018

Cause

The date/time format in Xtraction set as am/pm has some problem and does not show "am"

Resolution

Customer resolved through a configuration in Xtraction side. He changed the date/time to 24H, instead of am/pm.