Date/time format in MS SQL Server reports is not in a readable format (Epoch date).

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:

Re: Date/time format in MS SQL Server reports is not in a readable format (Epoch date).

-Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jay Sytangco Sent: Thursday, May 08, 2008 4:24 AM To: arslist@ARSLIST.ORG Subject: Date/time format in MS SQL Server reports is not in a readable format (Epoch date). Hi everyone

Re: Date/time format in MS SQL Server reports is not in a readable format (Epoch date).

Subject: Re: Date/time format in MS SQL Server reports is not in a readable format (Epoch date). I apologize in advance for not having all the details, but we did this at a company I used to work for. What you want to do is look through the Work Log field and find a special character that occurs

Re: Date/time format in MS SQL Server reports is not in a readable format (Epoch date).

: Thursday, May 08, 2008 8:34 AM Subject: Re: Date/time format in MS SQL Server reports is not in a readable format (Epoch date). ** There are actually two special control characters that are used to store diary field entries in the database. Unicode value 0003 is the END OF TEXT control