blanking out a Microsoft Access date/time field
Posted on 2002-04-11
I'm writing a program, where there are tasks assigned to people with a due date. The due date can be blank, if no due date is set.
Everything works fine, except when there was a due date, but the user changes it to become blank again. I'm trying to run a update query to blank the due date out but it's not working.
Using coldfusion, how can I take a date/time Access 2000 field with a date in it, and take out the date (leaving it blank)?