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 KNOWLEDGE TOOLS 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.

Cause

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

Environment

Xtraction 2018

Resolution

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