Hi everyone, This issue is specifically for the Diary fields. When diary fields are displayed in MS SQL Server reports, is there a way that we can identify the date/time from the rest of the data and format it as Date/ Time format?
Example Problem Log report: ----------------------------------------------------------------------------------------------------------------------------- Problem Log 1209364923 ramirec2 Ticket submitted with the following initial values: problem description = Testing for Status Bar in TT form problem area = ADM Outsourcing-Remedy-Application priority = Other assignee = Chidmark Ramirez notify by = Contact Profile support level = 2 business critical = No ETF/UOM = 0 1209364923 telalert TelAlert: AlertID=9770, Recipient/PIN=ramirec2, Alert Status = Accepted 1209365370 ramirec2 Testing only. System Note: Status was changed to Closed ------------------------------------------------------------------------------------------------------------------------------- Note: We have no problem converting date/time fields into date/time format - ONLY for date/time in Diary fields. Thanks in advance for your help. Jay _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
