Implemented: Add date filter to retrieve and display only courses that are not expired
Content from database:
Retrieve courses from table “fbu_extcal_courses“
Example SQL:
Update the existing SQL to ‘enddate‘ > today (courses that are not expired)
$fbu_extcal_query = ” SELECT * FROM fbu_extcal_courses WHERE programs LIKE ‘%500%’ AND display = ‘Y’ AND language LIKE ‘%$language_nm%’ AND startdate > ‘2020-01-01’ ORDER BY startdate DESC”;
3 thoughts on “Doctoral Level CEUs for courses not expired”
Remove the fixed temp date criterion, use a real dynamic date criterion.
Done, please check and let us know if any change.
Closed