Access SQL statement help

[Chad J]

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
AND
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?

[DaveMaxwell]

If it's access then the SQL statement should be:

strSQL = "SELECT * FROM events WHERE publish <= #" & dateToday & "# AND expire_date >= #" & dateToday & "# ORDER BY first_day ASC"

Dates in Access need to be surrounded by # for some bizarre reason

<edit>OK, putting this in the code tag with linebreaks makes it unreadable for some reason.....I'll make it all on one line like you had it so it can at least be readable[img]images/smilies/goof.gif[/img]</edit>

[Chad J]

Dave - you know - I had tried this and it did not work, but I copied it straight from your post and it does work - go figure.

Thanks so much for the help!

[DaveMaxwell]

Glad to help.