Add time from a date/time field

  • Thread starter Thread starter Qaspec
  • Start date Start date
Q

Qaspec

I have a column named PlannedStartDate that contains a date/time field
(ex:2/29/2008 3:15:08 PM) in another column i want to to show what the
date/time would be in exactly 2 hours.
 
A better method might be to use the dateAdd function.

Zero Hour: DateAdd("h",2,[Planned Start])

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

Qaspec said:
Figured it out.
Zero Hour: ([Planned Start]+(1/12))

Qaspec said:
I have a column named PlannedStartDate that contains a date/time field
(ex:2/29/2008 3:15:08 PM) in another column i want to to show what the
date/time would be in exactly 2 hours.
Click to expand...
Click to expand...
 
Back
Top