I would like to replace a DateTime value with a NULL value in a particular view, when the user chooses a certain option. I'm getting an error "Not a character expression".

Can I REPLACE the value of a datetime field in a cursor with a NULL?

*=============================
REPLACE CompleteDate WITH NULL
*=============================

I need to be able to display other options based on whether or not a Completed Date and Time have been entered. On top of that, I need to be able to "un-complete" the entry if need be (ie, null out an entered CompletedDate for a given record).

I have not yet added a boolean field for Completed because I thought I could just use the value of the date fields. Should I rely on a boolean field instead?

Any suggestions? Thanks!