ADO compatible with '1-JUN-01' dateforma

Results 1 to 2 of 2

Thread: ADO compatible with '1-JUN-01' dateforma

  1. #1
    Bas Emmens Guest

    Default ADO compatible with '1-JUN-01' dateforma

    Hi,<BR><BR>I&#039;d like to use a standardized date-format for accessing my Oracle and SQL-Server databases using ADO.<BR>Typically this is done with the &#039;dd-mmm-yy&#039; dateformat, which is commonly understood and avoids internationalization issues like dd-mm vs mm-dd confusion.<BR><BR>However, when I do a FIND operation on a RecordSet (ADO) the &#039;dd-mmm-yy&#039; format is not accepted:<BR><BR>ASP Error occurred 7-6-2001 9:58:45 in Provider<BR>Error number: -2147352571 (0x80020005)<BR>Type mismatch.<BR><BR>Doesn&#039;t ADO understand dateformats like &#039;01-JUN-01&#039; ?<BR>I use ADO 2.6 on Windows 2000 sp2.<BR>I can&#039;t find the answer in my documentation (Wrox).<BR><BR>Thanks,<BR>Bas.

  2. #2
    Join Date
    Dec 1969

    Default RE: ADO compatible with '1-JUN-01' datef

    Use the formatdatetime function to convert it to an acceptable ADO standard, i.e. :<BR><BR><BR>formatdatetime("1-Jun-01",2)<BR><BR>will become 01/06/01<BR><BR>MikeD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts