In my understanding the date  param in access u should use #
Ie: select id_invoice, name where invoice_date=#2003-12-02#


regards
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

-----Original Message-----
From: Jochem van [Hassan Arteaga Rodriguez] Dieten
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 09:26 AM
To: CF-Talk
Subject: Re: Date format in access

Shahzad.Butt said:
>
> Can someone tell the date format to use in CFQuery in select/insert
> statement for an access DB?

cfqueryparam + a date object.

Jochem
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to