Recording date and time together

  • Thread starter Thread starter Shelby
  • Start date Start date
S

Shelby

How can I format a field in a table to record both the
date and time? I need to be able to calcuate the
difference between two date/time entries.
-Shelby
 
Shelby,

What you need in the table is to format the date/time to
be general. this will give you the date and time. Then
using the right syntax you can calculate date/times. This
syntax is best explained in the help for access. The
expresion builder has all the proper syntax to use when
building the criteria in the query. Date time strings can
be rather lengthy since you have to specifiy the correct
portion of the date/time field to run the calculation on.

Kevin
 
i must be doing something wrong, because I tried
formatting it that way, and couldn't get it to show both
pieces. I'll play with it a little more. Thanks!
 
How can I format a field in a table to record both the
date and time? I need to be able to calcuate the
difference between two date/time entries.
-Shelby
Click to expand...

Use a Format of "Long Date", or a format which includes both date and
time portions such as

"dd-mmm-yyyy hh:nn:ss"
 
Back
Top