[AccessD] New thrd: dates

Bill, 

If you want a FE timestamp that could possibly be OK, and a BE timestamp would
probably be done by a stored proc initiated when the entry was added/changed -
with deletion being recorded as a change for audit path, and maybe recovery.

However there is local 'Summer' time to consider - as in you probably want to
avoid an entry indicating  a record was deleted sometime in the hour BEFORE it
was created. 
And there is even more fun when a government decides to change the usual
Summertime period.

To my mind it is best to use the organisations 'home location Standard time' as
in if the organisation is 'based' in NewYork all timestamps are using the
standard time there.
 
It will still be appropriate for many sets of data to include a local timestamp.

Having both allows the results of searches to be shown in timesequence for both
local (legal) purposes, and worldwide for corporate purposes.

JimB

And Bill, please keep asking the questions that are awkward to answer certainly
gets the forum thinking and even some edukatun

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Friday, August 22, 2014 1:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] New thrd: dates

Love - and am deeply grateful for, Stuart, the simplicity in that answer.
And the best part were the words "I always use" - which shows this is
field tested.

As a side question, I assume you use simply now() when time stamping an
access date field on the FE or BE regardless of the location, but what
happens when performing a loop and you want to insert all records with no
possibility of time stamp variation, such that you hold a date in
A variable like

dtStamp= Now ()

Do

    Blah blah inserts record with dtStamp

Loop

Do you use any conversion functions or rely on dtStamp to be a number?
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com