Solved

blanking out a Microsoft Access date/time field

Posted on 2002-04-11
3
141 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

867 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now