[AccessD] How do I

John,

Try this 
TIMEVALUE(#12/07/2001 10:43:56 AM#)

Patti


> -----Original Message-----
> From: John W. Colby [mailto:jwcolby at colbyconsulting.com]
> Sent: Wednesday, April 07, 2004 01:03 AM
> To: AccessD
> Subject: [AccessD] How do I
> 
> 
> 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
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>