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!