hjælp til forespørgsel

<% set chance = openrecordset("select * from SMSChancen_Log where closed = 0 AND chance = 'DagsChancen'") %>
<% Set rs = OpenRecordSet("SELECT count(ID) as tilmeldte FROM smschancen WHERE Chance LIKE 'tiba DagsChancen' AND (" & chance("Date_end") & " BETWEEN DATEADD(hh, - 24, { fn NOW() }) AND { fn NOW() })") %>


den melder at der er syntax error....???