You have a couple of options:
1) set the default in the database as:
Now() -> Access
GetDate() - > SQL Server
2) insert date by calling the DB's date function
Access:
insert into x (y)
values (Now())
SQL server:
insert into x (y)
values (GetDate())
Duane Boudreau
CFExperts.Com
-----Original Message-----
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 29, 2000 2:44 PM
To: [EMAIL PROTECTED]
Subject: Re: Inserting the Date in Access????
They might want to change the format to short date, otherwise it also show's
the time.
----- Original Message -----
From: "Oblio Leitch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 29, 2000 1:31 PM
Subject: Re: Inserting the Date in Access????
> The best solution I can think of:
>
> If all you want to do is record the date an entry into the database was
> made is set the "default value" of the field to "Now()".
>
> -Step-By-Step-
> 1. Open the database in Access
> 2. "design" the table (highlight the table; click "design" on the left)
> 3. select the field you want to contain the date
> 4. (make sure the data-type is "date/time"). select the "Default Value"
> field at the bottom
> 5. Type "Now()" (without quotes) in the blank
> 6. save and exit
>
> It's very simple, and you'll never need to worry about inserting the
> data. The real confusing thing is that the VB (Access's language) command
> and the CF command are the same (Now()).
>
> Hope this helps.
>
> Oblio
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
