I assume this is an Access DB? When you update the record you need to make
sure you updqate the datetime field too. i.e.
UPDATE <tablename>
SET <field1> = <value1>
, <field2> = <value2>
..
..
..
, <timestamp field> = Now()
WHERE <where clause>
-----Original Message-----
From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
Sent: 23 August 2000 14:11
To: [EMAIL PROTECTED]
Subject: Another date/time question
This is a multi-part message in MIME format.
--------------C29794390E2480E078234655
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
I have set my date/time field "datetime" to a default value
of Now(). That works great for new records that are added.
I can display that date field (e.g. "Last Updated
#CreateODBCDateTime(datetime)#"). My question, though, is
about updates - my users can update some of the fields in
that table with updated/more recent info, and I'd like to
change that date/time field to reflect these changes.
Do I do a CFSET on the datetime field? Any ideas / help
would be greatly appreciated!
Jamie
--------------C29794390E2480E078234655
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Symonds, Jamie
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Jamie Symonds
n: Symonds;Jamie
adr: Box 780;;St. F.X.U.;Antigonish;Nova Scotia;B2G 2X1;Canada
email;internet: [EMAIL PROTECTED]
title: Bachelor of Information Systems, Major (student)
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
version: 2.1
end: vcard
--------------C29794390E2480E078234655--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
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.
