Does "Date()" represent today in Access?If so you need GetDate() in SQL Server.GetDate() will return the current date and the time.If you just want the date the fastest (but somewhat hard to read!) method is:DateAdd(Day, DateDiff(Day, 0, GetDate()), 0)If your TODAY_IN_HISTORY.Date column stores the time too, but you want everything "today", then you will also need to strip off the time part of the value before you compare it:SELECT *FROM TODAY_IN_HISTORYWHERE DateAdd(Day, DateDiff(Day, 0, TODAY_IN_HISTORY.[Date]), 0) = DateAdd(Day, DateDiff(Day, 0, GetDate()), 0)
"Date" is a reserve word, so as your column is called "Date" you may need to use [ ] around it, but SQL Server is pretty smart so as the usage here is unambiguous I don't think you will need to explicitly escape the column name in that way, but it would do no harm!.Kristen 
Query
Posted - 2006-01-01 : 06:36:17
