John W. Colby
jwcolby at colbyconsulting.com
Wed Apr 7 06:18:28 CDT 2004
Interesting. I tried that in a query and got #error for values. I'll look at it again. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Wednesday, April 07, 2004 1:21 AM To: Access Developers discussion and problemsolving Subject: Re: [AccessD] How do I On 7 Apr 2004 at 1:03, John W. Colby wrote: > Having a bit of a problem tonight. > > Given #5/11/2000 3:20:00 PM# > > How do I get rid of the date portion and return just the time? > CLng rounds rather than truncates so myDate - CLng(mydate) will return a negative value if it is after midday. Use Int() instead myDate - Int(myDate) retuns the fractional part (ie the time) -- 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