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#'