I am using TD 8.0. I have an issue with the date formats used in the standard defect reports. Some dates are yyyy-mm-dd and some are US format mm-dd-yy. All I want is UK format dd-mm-yy. Is there any way of making changes to the reports in TD? Editing a template for example? Can I build a report from the ground up?
The easiest and suggested method is to change the date format on the client machine where the report is run from. The report will take on the machine's format and even though it is transferred to another machine with a different format it will display the original machine's format.
To change the client machine's format open the Control Panel and open the Regional and Language Options. Select the Regional Options tab and click on Customize. Then select the Date tab and pick your format.
Thanks Rich. Sadly the client machine (mine) is already set up with the expected date format. I ran the report builder today and that produces dates in the expected format. I am currently assuming that the formatting commands and the report code is hidden away in dlls or exes somewhere. Oh well....
I was reading quickly through the announcement of Servicepack 2 for TD 8.0 and there was an issue with date format in reports. Mercury announced a list of fixed problems for SP2. I suggest you take a look at it when it's available.
Dates are coming out of the OTAXML.dll before being transformed by the xsl with a hard format rather than the localized date. Mercury has to correct this to get the right date formats. Hopefully the SP fixed this.
Can someone explain what the issue is, please? I went and tested this on our installation and saw no problem, when I set the client machine to a different country's date format, the report printed out in that format. I must be missing something. I do know that you can setup xsl templates for different countries, but the OS changed seems much simpler.