Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Web Help Desk (WHD) > 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: 79 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
04:38, 23 Jun 2016

Tags

Classifications

Public