[AccessD] How do I

Hi John,

If it weren't for those # #'s, I'd say
Format("5/11/2000 3:20:00 PM","Long Time")

----

Michael R. Mattys
(724) 942-3437

Mattys MapLib for Microsoft MapPoint
http://www.mattysconsulting.com



----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Wednesday, April 07, 2004 1:03 AM
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