[AccessD] How do I

O'Connor, Patricia Patricia.O'Connor at DFA.STATE.NY.US
Wed Apr 7 13:21:19 CDT 2004


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
> 



More information about the AccessD mailing list