I have a simple question...
My question is, "What is the correct way to do this date comparison?"
The way I'm doing it now doesn't work.

I have my data in an Access table
I have a field (Start_Time), declared as a Date/Time
I want to return all records where the Start_Time is from today.

The select statement I'm using is

SELECT Activities.Unique_ID as Activity, 
		Activities.Contact_ID as Contact, 
		Contacts.Company as Company, 
		Activities.Type, 
		Activities.Start_Time as StartDate, 
		Activities.Duration, 
		Activities.Priority, 
		Activities.Regarding, 
		Users.User_Name as For_User, 
		Activities.recurring_freq as Frequency, 
		Activities.recurring_until as Recurring_Until,
 		Activities.Completed as Completed 
	FROM (Activities 
		INNER JOIN Users 
			ON Activities.schedl_for = Users.Unique_ID)  
		INNER JOIN Contacts 
			ON Activities.Contact_ID = Contacts.Unique_ID 
	WHERE  (Activities.Schedl_For = 26)  
		AND  (Activities.Start_Time = 6/17/2004)  
	ORDER BY Activities.Start_Time DESC 

The WHERE clause is actually being build in code...

...
                myProposedFilter = myProposedFilter & " AND " & _
                " (Activities.Start_Time = " & Today() & ") "
...
Session("myProposedFilter") = myProposedFilter
...
SelectCommand = "SELECT " & _
                      "Activities.Unique_ID as Activity, " & _
                      "Activities.Contact_ID as Contact, " & _
                      "Contacts.Company as Company, " & _
                      "Activities.Type, " & _
                      "Activities.Start_Time as StartDate, " & _
                      "Activities.Duration, " & _
                      "Activities.Priority, " & _
                      "Activities.Regarding, " & _
                      "Users.User_Name as For_User, " & _
                      "Activities.recurring_freq as Frequency, " & _
                      "Activities.recurring_until as Recurring_Until, " & _
                      "Activities.Completed as Completed " & _
                   "FROM (Activities INNER JOIN Users ON Activities.schedl_for = Users.Unique_ID) " & _
                          " INNER JOIN Contacts ON Activities.Contact_ID = Contacts.Unique_ID " & _
                   "WHERE " & Session("myProposedFilter") & _
                   " ORDER BY Activities.Start_Time DESC "

TIA,
Rick