Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

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,143 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