I have an SQL statement which is acting funky. I can't get the result set I want.
SelectStatement = "SELECT * FROM events WHERE (publish <= " & dateToday & " ) AND (expire_date >= "& dateToday & " ) ORDER BY first_day ASC"
publish = date/time
expire_date = date/time
first_day = date/time
dateToday = Date
All I want are results that the
'publish' date is before and including today
today is equal to or less than 'expire_date'.
These are articles that have a publish and expire date. They should be included in the result set if 'dateToday' fall in between those dates.
I don't get any results with this query - but no errors. Am I missing something?