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.