Using datetime with EQUALS currentdate

[Luvsql]

I would like to simply find records with a datetime field = currentdate. Because it's a datetime, it will only find a match if the time and seconds match. How do I just look at the date portion and compare to currentdate?

 

[lbass]

Actually this should work without converting it to a date--you should test that to make sure using your database. It works for me.

Otherwise you would just use:

date({table.datetime}) = currentdate

-LB

 

[Luvsql]

Sorry I entered the syntax from the crystal report I was working on. In SQL, the syntax is; select * from table where createdate=getdate()

This does not work even though I see records with a create date of today.

 

[lbass]

Are you using a command then? What type of database?

-LB