Results 1 to 9 of 9

Thread: Datetime error 80040e07 on Update statement (DWUD)

Threaded View

  1. Jan 17th, 2003, 03:54 AM #1
    Chrissie
    Chrissie is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2002
    Location
    The Netherlands
    Posts
    96

    Datetime error 80040e07 on Update statement (DWUD)

    I have a problem with updating a field which hold a datetime. When I use <%=NOW%> for inserting a datetime into my MS SQL database everything goes well....When I try to update this by using <%=NOW%> it returns the following error...

    Code:
    [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to 
a datetime data type resulted in an out-of-range datetime value.
    I have been trying to convert and format the time in many many different ways for a few days now....does anyone know how to solve this problem?
    Last edited by Chrissie; Jan 17th, 2003 at 04:03 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width