date problem

Select DISTINCT(datetime) From calender WHERE (adid = 1) AND id IN (select ID from calender where datetime BETWEEN #1/4/2004# AND #31/4/2004#)

Varför får jag:

Line 1: Incorrect syntax near '#'.

Select DISTINCT datetime 
 From calender 
WHERE adid = 1
 AND datetime BETWEEN '2004-04-01' and '2004-04-31'

Vad som är korrekt beror på vilken dbms det gäller.

jepp :)