[AccessD] How do I

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






More information about the AccessD mailing list