Index: lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java =================================================================== diff -u -rc9c56707245e3ad1149bf1a5338eb251c96c75d2 -r7018be36a82c019346769f40ec232c4412bb4cf1 --- lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision c9c56707245e3ad1149bf1a5338eb251c96c75d2) +++ lams_common/src/java/org/lamsfoundation/lams/lesson/dao/hibernate/LessonDAO.java (.../LessonDAO.java) (revision 7018be36a82c019346769f40ec232c4412bb4cf1) @@ -36,7 +36,7 @@ + Lesson.class.getName() + " lesson where lesson.learningDesign.copyTypeID=" + LearningDesign.COPY_TYPE_PREVIEW - + "and lesson.start_date_time < ?"; + + "and lesson.startDateTime is not null and lesson.startDateTime < ?"; /** * Retrieves the Lesson