5 Replies Latest reply on Jan 25, 2007 5:20 AM by Newsgroup_User

    Insert current date CF & MS SQL

    Level 7
      I am attempting to update a field with a current date using cfquery and SQL.
      How can I do this? I tried (CurrentDate()) and Now(). The field is set to
      SmallDate. Thanks!

      UPDATE [Moot Court Invitation]
      SET [invite?] = 1
      [invitation date] = #Now()#
      WHERE peopleid = '#arguments.pcode#'