Solved

blanking out a Microsoft Access date/time field

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

708 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

18 Experts available now in Live!

Get 1:1 Help Now