Solved

blanking out a Microsoft Access date/time field

Posted on 2002-04-11
3
149 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:mcon1
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
cheekycj earned 50 total points
ID: 6934462
can't you just set it to null.

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

CJ
0
 
LVL 1

Author Comment

by:mcon1
ID: 6934495
sweet!

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

mcon1
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 6934911
no prob, Glad I could help.. Thanx for the "A".
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question