Creating a view based on current date data 1

[TeriCoombes]

I am having a problem with my SQL statement. I am trying to query out results in a table based on a date column. However, when I try:

WHERE (dbo.tblTestResults.LastModified = Date())

I get an ADO error that says Date is not a recognized function.

When I try:

WHERE (dbo.tblTestResults.LastModified = GetDate())

then I don't get any results at all when I know there are some. The same thing happens if I try:

WHERE (dbo.TestResults.LastModified = { fn CURDATE() })

Please help.

 

[mrdenny]

Datetime columns and the getdate system function both store dates and times to the milisecond. You have to convert them into a usable date only string to do this compair.

where convert(varchar(10), dbo.tblTestResults.LastModified, 101) = covnert(varchar(10), getdate(), 101)

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[TeriCoombes]

Thanks! It totally worked!

 

[mrdenny]

cool.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)