[AccessD] New thrd: dates

Stuart McLachlan stuart at lexacorp.com.pg
Fri Aug 22 16:02:06 CDT 2014


You can just use dtStamp.   .Same as you can safely use Now() directly for a simgle date 
stamp.

The problems only occur when using external representations of dates derived from  GUI 
controls - it is the interpretation of string representations of dates that cause them.

-- 
Stuart

On 22 Aug 2014 at 8:58, Bill Benson wrote:

> 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
> 




More information about the AccessD mailing list