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