The following code works fine when I preview it locally. When I load it to my site I get the following error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/hrc/index.asp, line 163
rs_opening.Source = "SELECT * FROM EventTable WHERE DatePart("d",Opened) & DatePart("m",Opened) = DatePart("d", Now()) & DatePart("m", Now())"
----------------------------------------------------------------^

Please can someone advise what I have done wrong?

Thanks

Perry

....It's only easy if you know the answer