Adjusting Date and Time

[rjvega]

I have a database that collects time stamps of material movement through a
certain area. It's great for collecting metrics. This initial loading of
data, however, requires that they enter the Dock Date of the material and we
do not know the time this happened -- only the date. As such, they are
entering the date only.

I noticed that my metrics were a bit off, and then I realized that all the
times associated with the Dock Date were 12:00:00 AM. Since I'm calculating
delays in the system, I need to associate a time with the Dock Date, but it
would be more accurate if I could estimate a 12:00:00 PM time.

Where I need help is in converting the existing data so it changes the time
from 12:00:00 AM to 12:00:00 PM. Can someone help?

 

[John Spencer]

You can use an expression

DateAdd("h",12,[Dock Date]) to calculate the time as 12:00:00PM.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================