blanking out a Microsoft Access date/time field

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)?

thank you

mcon1
LVL 1
mcon1Asked:
Who is Participating?
 
cheekycjConnect With a Mentor Commented:
can't you just set it to null.

update yourtable
set datefield = NULL
where datefield > #CreateODBCDate(Now())#

CJ
0
 
mcon1Author Commented:
sweet!

I knew there must be an easy way to do it.  Thank you for the quick reply.
:)

mcon1
0
 
cheekycjCommented:
no prob, Glad I could help.. Thanx for the "A".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.