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]
> Subject: Default value for
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 (
