Sill want to SELECT a Date...

[adamsoderqvist]

I placed this question a few days back, but didn't seem to get a sufficient answer...(though I appreciate the effort! )

I'm trying to retrieve posts in Access by todays date (as in a
guestbook).But it won't work.

This what i have:

SELECT PostDate, Subject, Message FROM tblMessages WHERE PostDate = #" & Date()& "#"

...and this is the error-msg returned:

"ADODB.Recordset error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."

- Yet there is a record and, as I said, it works when I retrieve by other parameters such as the actual Message body or by subject!

 

[GingerR]

found this article at MS that addresses your problem:

http://support.microsoft.com/support/kb/articles/Q230/1/01.ASP

 

[tlbroadbent]

Is it possible that PostDate contains time values as well as the date as in "9/10/01 14:22:34?" If so, try the following. The Int function strips the time portion of the datetime column.

SELECT PostDate, Subject, Message
FROM tblMessages
WHERE Int(PostDate) = Date() Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous