compare dates

  • Thread starter Sergey Bogdanov
  • Start date
S

Sergey Bogdanov

Hello,

is there any "lightweight" solutions to compare date/time with certain date.
For example the folowing comparision is true -- 2003-10-10 23:00:00 and
2003-10-10

I've tried to code the folowing but it doesn't work :(

SELECT t.dates, *
FROM t
WHERE Date(t.dates)=#2003-10-10#

thnx,
Sergey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date comparing 1
Checking for date and time overlaps 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Sorting by time starting from a specified time. 4
Graph usage for times of day 0
Changing constants in a query to user input values 2
End Date/Time adding business hours 1
Add Hours by Looping through Data Q 27

Top