View Single Post
  #3 (permalink)  
Old October 13th, 2005, 06:42 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Actually, the query above will return only the most current record. If there is more than one record with the latest date, then you may want to sort on another field as well to get the one you want.

The second alternative will give you all the records with TodaysDate.


mmcdonal
Reply With Quote