date format

  • Thread starter Thread starter smk23
  • Start date Start date
S

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
 
How are you passing it?

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