Posted on 2009-07-06
I need to return 'm/d/yyyy' for 'Business Date' and 'm/d/yyy 6:30 pm' for 'Time Submitted. How do I change the values?
managerlog.Check_file_date as 'Business Date',
managerlog.TimeSubmitted as 'Time Submitted',
vUser_Info.First_Name as 'First Name',
vUser_Info.Last_Name as 'Last Name',
managerlog.Notes as 'Notes'
FROM ManagerLog ManagerLog INNER JOIN vUser_Info vUser_Info ON ManagerLog.UserID=vUser_Info.UserID