Help with a variable

[KCDoodle]

I have a sql statement that is using a variable

$resultID = @mssql_query("SELECT TOP 10 DailyStats.AgentName, Sum(tbl_DailyStats.CallsPerDay)
FROM tbl_DailyStats
GROUP BY tbl_DailyStats.Date, tbl_DailyStats.AgentName
HAVING (((tbl_DailyStats.Date)=$TodayIs))
ORDER BY Sum(tbl_DailyStats.CallsPerDay) DESC", $sqlid);

$TodayIs = 09/03/2002 but it won't pull the query, if I type 09/03/2002 it will pull the query

Thanks
Jim

[Spookster]

try

HAVING (((tbl_DailyStats.Date)='$TodayIs'))

[KCDoodle]

Thank you it worked perfect!