View Single Post
  #2  
Old April 27th, 2010, 09:41 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Calculate 30 minutes earlier

Adjusted Time: DateAdd("n", -30, [YourDateField])

--
Build a little, test a little.


"Tim" wrote:

Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!