[AccessD] How do I

Jim,

This is older data from my billing program.  I'm trying to set up a
collision checker so that as I enter times the times are checked for
collisions with existing billing records, so I really have to get rid of the
time.  TimeValue() did the trick.  Just updated those records > 1 and I'm
off and running.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman
Sent: Wednesday, April 07, 2004 9:07 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] How do I


John,

  One thing you can do is continue to use the date/time field, but just
ignore the date (set them all to 0) and use Format$() for displaying the
time only.

Jim Dettman
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Wednesday, April 07, 2004 1: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