Brooks, The AR ODBC driver is the best bet for that conversion. Without that you will need to do all the conversions yourself and its not just the date and time but conversions like values of drop list fields which will be enumerated values, names of columns which will be C1, C2.., Status history values if you need to report them, etc if you report directly using a SQL connector.
What errors are you getting when you try connecting to the database using the AR ODBC driver? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Friday, January 04, 2008 3:30 PM To: [email protected] Subject: HPD_HeldDesk Worklog timestamp conversion Hello All I am using SQL Server Reporting Services for my reporting application and the ARSystem ODBC driver is throwing up errors when I use it to connect to ARSystem, so I am connecting directly to the database for my reporting. Is anyone else running into this problem? If not, can someone tell me how I can get the Work Log to display properly formatted timestamps in a direct sql query that looks like this:8/26/2006 2:36:22 PM and not like this: 1155331936 Thanks Brooks ARSystem 7.00 SQL Server 2005 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008 12:05 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
