Today's date not located in table (1 Viewer)

[Kayleigh]

Hi
I am having trouble with a query in SQL Server. I am trying to locate the records created on today's date.
I have a field which logs the date it is created but whichever way I try, the results are always blank. It does sometimes works in MS Access.
Here is the SQL of my query:

SELECT  cast(fldocreated AS Date) AS dates
FROM dbo.tblOrders
WHERE cast(fldocreated AS Date)=getdate();

 

[pbaldy]

GetDate() returns the data and time (like Now()), so you'll have to cast that too.