Below returns zero recordset from the stats table (when I know there are 100's):
<cfset today = createDate(year(now()), month(now()), day(now()))>
<cfset yesterday = dateAdd("d", -1, today)>
<cfquery name="GetAptsStats" datasource="#DSN#">
SELECT listingFk, listingId, timeStampStats...