John W. Colby
jwcolby at colbyconsulting.com
Wed Apr 7 00:03:23 CDT 2004
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?
I tried subtracting the clng(ThatDate) from the whole... sometimes worked
but sometimes gave me bad time (but never any date portion)
I tried dateadd("d",-clng(ThatDate),ThatDate)... That always gives me the
correct time but 12/29/1899 as the date portion if the time is in the PM.
I have a bunch of times that include the date and I need to strip the date
off the time.
John W. Colby
www.ColbyConsulting.com