[AccessD] How do I

John,

Two thoughts.

1. Can you count back from the right until you find the blank and
isolate the time?

2. Can you convert the current format to a decimal number 12345.12345
and then convert the decimal to time.

JOE HECHT
LOS ANGELES CA 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Tuesday, April 06, 2004 10:03 PM
To: AccessD
Subject: [AccessD] How do I

Having a bit of a problem tonight.

Given c

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