Date Default Value

[Bob Day]

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

 

[Steven Bras [MS]]

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
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or to
visit Windows Update at http://windowsupdate.microsoft.com 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.

 

[Bob Day]

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

Bob