Try using the following:-
Format(Date,"-mm-dd") instead of
???/
> -Original Message-
> From: Apolinaras "Apollo" Sinkevicius [SMTP:[EMAIL PROTECTED]]
> Sent: 15 January 2001 20:43
> To: [EMAIL PROTECTED]
&
MySQL only supports constant default values. You'll have to insert
the date explicitly when you create the record if you want to simulate
initialization to now().
Timestamps will update themselves whenever any other field in the
record changes, unless you explictly tell them not to. So they are
Use the timestamp datatype, not date.
At 02:43 PM 1/15/2001 -0600, Apolinaras \"Apollo\" Sinkevicius wrote:
>I would like to set a default value in DATE type column to Date(), but it
>doesn't work. Is there a way to do it through column format?
>If not, what should I enter in the VB code below (
I would like to set a default value in DATE type column to Date(), but it
doesn't work. Is there a way to do it through column format?
If not, what should I enter in the VB code below (place where I need help
will have )
Private Sub okButton_Click()
Dim db As Database
Dim r
