Returning a query with #now()#
Posted on 2013-01-03
I'm having some trouble returning results from a query. I am using SQL server 2008 and the field (enterDate) is set as a dateTime in the table. When I run the query below, it does not return any records although there are records in the DB that should be returned. Any suggestions would be appreciated. EnterDate field in the db looks like this....
<cfquery name="getBillable" datasource="#application.dsn#">
where email = '#form.email#'
and enterDate = #dateFormat(now(),'yyyy-mm-dd')#