# in string/datetime SQL query

[Eric Bobo]

Sorry here is my correct email

I'm trying to create a string to query an ACCESS database with a
datetime field. In order to query a datetime field I need to enclosed
the timestamp with #

WHERE Sign_date > #1/2/2003 5:52:39 PM#

No matter what I do I cannot create a string in ASP with two # in it.

Even the simple statement like
dim junk
junk = "####"
returns 1 # sign. (ie respons.write junk = "#")

How can I build a string with the datetime wrapped in # or am I missing
something here?

Thanks

Eric