[AccessD] How do I

Stuart McLachlan stuart at lexacorp.com.pg
Wed Apr 7 00:21:19 CDT 2004


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.






More information about the AccessD mailing list