by roylayer » Fri Mar 12, 2004 11:15 pm
Inside Access, dates are delimited by # symbols. Thus, today's date would be #3/12/2004#. A query that returns all songs played today looks like
Code: Select all
SELECT Songs.LastTimePlayed, Songs.*
FROM Songs
WHERE (((Songs.LastTimePlayed)>#3/11/2004#));
Remember, the date is really made up of date AND time, so changing my Where clause to
would not have the same effect. Also, I'm not sure how the different local date formats affect your queries, but that's something to be aware of as well.
Hopefully this will help some.
Inside Access, dates are delimited by # symbols. Thus, today's date would be #3/12/2004#. A query that returns all songs played today looks like
[code]
SELECT Songs.LastTimePlayed, Songs.*
FROM Songs
WHERE (((Songs.LastTimePlayed)>#3/11/2004#));
[/code]
Remember, the date is really made up of date AND time, so changing my Where clause to [code]Songs.LastTimePlayed)=#3/12/2004#[/code] would not have the same effect. Also, I'm not sure how the different local date formats affect your queries, but that's something to be aware of as well.
Hopefully this will help some.