Show only records dates before Todays date
Hi Ray
Iv got a small problem with my dates i think.
there are stored in a column as named 'DateCourseDate' as DD/MM/YYYY do i have to do anything special to make
This is the recordset function
SELECT *
FROM course_dates
WHERE DateCourseLocation = colname AND course_dates.MP_DP = 'DP'
ORDER BY CourseId ASC
Should it be
SELECT *
FROM course_dates
WHERE DateCourseLocation = colname AND course_dates.MP_DP = 'DP' AND course_dates.DateCourseDate <= 'NOW ( )'
ORDER BY CourseId ASC
Sorry to be a pain but I'm a little lost any help is very welcome
Kind regards
John