Query Report shows numbers in Date fields...
Hi there,
I have attached some pictures in order to help you out on this.
1. Go to Reports ( as Admin)
2. Reports by Requests
3. Requests by technician
4. Press Edit to edit the request
5. Add "Completed Time" from the available columns to the Display Columns
6. Click "Run Report"
7. Click on Show query on the report
8. Click "open with query editor"
9. Click Run Report without making any changes. ( query.jpg)
10. On the Created Time and Completed Time field numbers are shown..... ( printscreen.jpg)
That might be helpful
We use MSSQL ( same thing happens with MYSQL as well) SQL Server 2005 , SD 7506 on Win2003 Server.
Kind Regards,
George