date format

[smk23]

I need to pass the value of Now() to a SQL statement. I am getting a syntax
error because what is being passed is '7/9/08 08:15:00 AM' . I am pretty sure
that it's the "AM" that's the problem. How can I get around this?

Thanks,
Sam

 

[Douglas J. Steele]

How are you passing it?

If you're creating the SQL statement via VBA, use the Format function on the
Now function call.