Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Dates on excel ticket import in wrong format

Dates on excel ticket import in wrong format

Created by Caroline Musindi, last modified by MindTouch on Jun 23, 2016

Views: 1,173 Votes: 1 Revisions: 4

Overview

This article describes the issue when after importing tickets from WHD, the date shows a wrong format.

For example: 15/10/2012 becomes 10/3/2013

Environment

  • All versions of WHD 
  • All versions of MS Excel

 

Cause 

This issue occurs because the Excel column format for the date is different.

 

Resolution

  • You can import in TSV format to fix the issue.
  • Select the date columns in Excel and apply the value shown below and then save the excel sheet.

 

 

 

 

 

Last modified

Tags

Classifications

Public