ASP searching databse for date part

[psycho quilla]

Hi,

I am working on a genealogy website and want to display on the home page a "on the day" function. I have worked out different methods to extract the date and month from current time with which to query the access database. Here I have become hoplessly stuck, this is the cose I am using:

DIM PartDay, PartMonth, ThisDay
PartDay = DatePart("d", Date())
PartMonth = DatePart("m", Date())
ThisDay = PartDay & PartMonth

Set objRS = Server.CreateObject("ADODB.Recordset")
MySQL = "SELECT * from Diary where Date Like '#" & ThisDay & "#'"
objRS.Open MySQL, objConn, 1, 3

i have also tried another variation querying the database with 23/03 but still no joy.

Please can somebody please tell me how to query a database date

Thank you

[PeejAvery]

Don't use LIKE with a date. Simply query the date as equal to string.

If the column is DATE type...
"SELECT * FROM Diary WHERE Date = 'YYYY-MM-DD'"

If the column is DATETIME/TIMESTAMP type...
"SELECT * FROM Diary WHERE Date = 'YYYY-MM-DD HH:MM:SS'"

[psycho quilla]

Thank you for your reply but I don't think I made my predicament clear enough in my original post.

I am trying to search for a part date for example 24 March or 24/03

so that this will then retrieve every matching date in any year.

Thanks again

[PeejAvery]

So, you still apply my same principle of SQL query, then add the LIKE statement.

"SELECT * FROM Diary WHERE Date LIKE '%-MM-DD'"