Is it possible to change the date format settings in Issue Manager?

0 Likes

Problem:

Is it possible to change the date format settings in Issue Manager?

Resolution:

ANSWER
----------------------------------
With the release of Issue Manager 4.0 this is possible using the following method:

  1. Got to ADMINISTRATION | USERS | SELECT USER
  2. Ensure correct TIME ZONE is selected,
  3. Select DATE FORMAT and SHORT DATE FORMAT to be used.


Prior to Issue Manager 4.0 it was necessary to do this using SQL functions in advanced queries with the CONVERT function. Please refer to SQL documentation on the possible parameters/values associated with CONVERT. Below is an example of how the query may be implemented:

SELECT DefectID, Synopsis, DateLastMod, CONVERT(VARCHAR(11), DateLastMod, 106), TimeLastMod 
FROM Defect D 
WHERE 
EXISTS ( 
SELECT * 
FROM DEFECT_HISTORY H 
WHERE H.DefectID = D.DefectID 
AND H.DateCreated = CONVERT(VARCHAR(11), GETDATE(), 102) )


Old KB# 23698
Comment List
Anonymous
Related Discussions
Recommended