[AccessD] New thrd: dates

Hi Bill

You would rely on dtStamp being a date/time value. The field would be of data type Date.

The records would be stamped identically with the value of dtStamp.
If you want the real time as close as possible, for example in a loop of long duration in VBA, you would call Now within the loop for each insertion.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Bill Benson
Sendt: 22. august 2014 14:59
Til: Access Developers discussion and problem solving
Emne: 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?