By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,290 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,290 IT Pros & Developers. It's quick & easy.

Date Default Value

P: n/a
Using vs.2003

Using Server Explorer, Design Table, what can I put in the default field for
a DateTime column?
Obvious things like (#12/12/2003#) don't work.

Please give me the answer specifically for the Default Field in the Design
Table dialog box, what the exact entry would be. These fields use different
formats than sql, so giving me an answer like use date.minvalue is useless
because it doesn't work that way.

What does?

Bob Day
Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Using SQL, worked perfectly - thanks.
The documentation on using these fields is zero. It needs to be improved.
(vs 2003).


"Steven Bras [MS]" <st******> wrote in message
I can only speak for SQL Server, which does accept a literal date like
'3/5/03'. I don't imagine you are using Access, so the # delimiter which is specific to the Jet engine most likely wouldn't work in your case either.

What's accepted in the default field would be specific to your database. If you post what database you are using, I may be able to assist further.

Steven Bras, MCSD
Microsoft Developer Support/Data Access Technologies

This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to
review the information at the following link regarding Microsoft Security
Bulletin MS03-026 and/or to visit Windows Update at to install the
patch. Running the SCAN program from the Windows Update site will help to
insure you are current with all security patches, not just MS03-026.

Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.