Re: Time format issue in while exporting incident data. (262 Views)
Reply
Trusted Contributor
vnarend
Posts: 212
Registered: ‎07-27-2011
Message 1 of 6 (339 Views)
Accepted Solution

Time format issue in while exporting incident data.

Hi Experts,

 

 

we have been facing some weird issue. We are exporting data from incident to excel sheet for reporting. Like last 30 days incidents.

 

In the excel sheet while exporting data the time format from 1 to 12th is coming in one format and 13th to 30th is coming in one format. Please find below open time and resolve time example.

 

Please help in find out what could be wrong.

 

When I check each record individually it showing same for 12th and 13th date.

 

13/06/2012 00:23:17 13/06/2012 00:37:39 13/06/2012 00:14:35 13/06/2012 00:31:45 12/6/2012 23:37 12/6/2012 23:51 12/6/2012 23:37 12/6/2012 23:50 12/6/2012 23:37 12/6/2012 23:50

Honored Contributor
Piku
Posts: 4,047
Registered: ‎06-17-2010
Message 2 of 6 (334 Views)

Re: Time format issue in while exporting incident data.

Hi,

Is it also different in qbe format before export

There might be some issue in excel too( i faced once issue that excel is having records in two format) so try to restart you SM client along with close all the open copy of excel.Also try to export in text file and check whether error is same in both.


hth,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Assign Kudo, if found post useful and mark it accepted if solves the issue.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
Honored Contributor
-m-
Posts: 989
Registered: ‎02-22-2011
Message 3 of 6 (317 Views)

Re: Time format issue in while exporting incident data.

The dates exported from SM to Excel are in dd/mm/yyyy format, but Excel is expecting it them to be in mm/dd/yyyy format. This is the reason the 1-12 dates appear different from the 13-3x dates.

Frequent Advisor
EMS-HP
Posts: 46
Registered: ‎07-11-2011
Message 4 of 6 (288 Views)

Re: Time format issue in while exporting incident data.

Hi m,

 

I am also facing the same problem while exporting data to excel file. 1-12 dates appear different from the 13-3x dates format.

I want to make all dates in single format. Please let me know it is possible or some work around to resolve this.

 

Giri Prasad,
EMS.
Advisor
darshana
Posts: 34
Registered: ‎01-02-2013
Message 5 of 6 (282 Views)

Re: Time format issue in while exporting incident data.

Hi,

Please try following steps on your workstation from where your opening excel sheet:
goto Control Panel->Regional and Language.
The short date field should match Service Manager's application date settings.

Thanks,
Darshana
Frequent Advisor
EMS-HP
Posts: 46
Registered: ‎07-11-2011
Message 6 of 6 (262 Views)

Re: Time format issue in while exporting incident data.

Hi Darshana,

 

Thanks for the solution and now it's working.

Giri Prasad,
EMS.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.