Hi All,
I'm having issues where the dates being retrieved from an SQL report are displayed incorrectly. The dates are displaying several months behind what they actually are.
Any Assistance is greatly appreciated.
SELECT concat(u.firstname," ", u.lastname) AS 'name',
co.fullname AS 'Course' ,
CASE
WHEN gi.itemtype = 'course'
THEN concat('<strong>',co.shortname,' Course Average','</strong>')
ELSE gi.itemname
END AS 'Item Name',
ROUND(gg.finalgrade,2) AS Grade,
DATE_FORMAT(FROM_UNIXTIME(gi.timemodified),'%d %M, %Y') as DATE
FROM prefix_course AS co
JOIN prefix_context AS ctx ON co.id = ctx.instanceid
JOIN prefix_role_assignments AS ra ON ra.contextid = ctx.id
JOIN prefix_user AS u ON u.id = ra.userid
JOIN prefix_grade_grades AS gg ON gg.userid = u.id
JOIN prefix_grade_items AS gi ON gi.id = gg.itemid
JOIN prefix_course_categories AS cc ON cc.id = co.category
WHERE gi.courseid = co.id
%%FILTER_COURSES:co.id%%
%%FILTER_USERS:concat(u.firstname," ", u.lastname)%%
ORDER BY lastname,firstname,course,gi.timemodified DESC
Stan.