Personnel Manager\Events\Training: Dates not showing

Orginator: SFC Mary Smith, NCOIC Ed Div., WBAMC
Alvarado, Daniel - MEPS Admin

Issue: Date does not show for any class based training
(Events).

Description: Any event entered using Classmanager does
not show the date
in /meps/personnelmanager/events/training.asp?
text=BLAHBLAhBLAH&internalmepsid=xxxx&orgentityid=x.x
.x.x&ssn=xxx-xx-xxxx.

The query
in /meps/personnelmanager/events/training.asp currently
is SELECT Events.[event-id] AS RowID, Courses.Code AS
CourseCode, Courses.EdCat, Courses.Title AS
CourseTitle, Events.[date] as CourseDate,
Events.Status, 'EVT' AS Source " & _
"FROM Events " & _
"INNER JOIN Classes ON Events.Class
= Classes.id " & _
"INNER JOIN Courses ON
Classes.CourseCode = Courses.Code " & _
"WHERE ((Events.Status = 'Pass') OR
(Events.Status = 'Failed') OR (Events.Status = 'no
show')) " & _
"AND (Events.SSN = '" &
PersonnelManager.SSN & "')" & vbCrlf & _
"UNION" & vbCrlf & _
"SELECT NonAppTng.id AS RowID,
NonAppTng.course AS CourseCode, Courses.EdCat,
Courses.Title AS CourseTitle, NonAppTng.[date] as
CourseDate, NonAPpTng.Status, 'NAT' AS Source " & _
"FROM NonAppTng " & _
"INNER JOIN Courses ON
NonAppTng.course = Courses.Code " & _
"WHERE (NonAppTng.ssn = '" &
PersonnelManager.SSN & "') " & _
"ORDER BY EdCat, CourseTitle,
CourseDate DESC

The line that shows Events.[date] as CourseDate
should reflect Events.[timestamp] as CourseDate to
accurately show the date for this training in
\meps\personnelmanager\events\training.asp.