|
| |
|
|
ChrisJ
Posts: 105
From: Flowery Branch, GA
Status: offline
 |
Updating Date Field - 12/28/2001 23:44:25
Quick question about updating an Access table using a form and the DRW. What I have below works fine to update one text field and one number field.
UPDATE Results
SET Text1='::Text1::', No=::No::
I also want to update a field formatted as a Date in Access. I get a syntax error using either of the above two formats (with and without single quotation mark.) How can a field formatted as a date be updated?
Thanks!
|
|
|
|
ChrisJ
Posts: 105
From: Flowery Branch, GA
Status: offline
|
RE: Updating Date Field - 12/29/2001 0:23:54
I found what was wrong - I was using DATE as the field name and needed to use [DATE]. Now that it works, one more question.
I want to be able to leave this form field blank at times. For my text fields, I just set the field properties in Access to "Allow Zero Length." I can't figure out how to do this for a field formatted as a date.
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Updating Date Field - 12/29/2001 19:29:30
Youll need to pass a default date to the database.
If its empty, '' isnt recognized as a date.
Adding a default date of 01/01/01 at step 3 should work.
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
