[AccessD] A2K: Getting incorrect date

Thanks Stuart
Exactly what i needed

Darren

----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Darren DICK" <d.dick at uws.edu.au>; "Access Developers discussion and problemsolving" <accessd at databaseadvisors.com>
Sent: Tuesday, April 27, 2004 8:29 PM
Subject: Re: [AccessD] A2K: Getting incorrect date


> On 27 Apr 2004 at 14:36, Darren DICK wrote:
> 
> > Hello all
> > Can anyone tell me why dtTimeElapsed  is returning a crap date around 1900 or so?
> > dtStartDate returns the expected date as does dtTodaysDate 
> > Many thanks
> > 
> > 
> > Dim dtStartDate As Date
> > Dim dtTodaysDate As Date
> > Dim dtTimeElapsed As Date
> > 
> 
> Because an elapsed period is not a date. It is a number.  DateDiff() returns *number* of time periods
> Dim dtTimeElapsed as a long  to get the number of  the time periods specified by the first paramter of DateDiff.
> 
> 
>  
> -- 
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com