View Single Post
  #2  
Old December 21st, 2006, 06:31 PM posted to microsoft.public.access.forms
Daniel
external usenet poster
 
Posts: 1,017
Default Date and Time in One field

yes, this is normal functioning of Date/Time fields.

now() = 12/21/2006 1:27:53 PM
date() = 12/21/2006
time() = 1:27:53 PM

all dates and times can be store in a date/time field as well as the
combination of both. Simply define your field as a Date/Time field in your
table and your off to the races!

Daniel




"wizmark" wrote:

I hope to generate date and time in a table combining date and time. Example:
ddmmmyyyy plus HH:nn (time in 24 hour format). Is this possible? I thought
I'd done it years ago but can't figure out how to do it now.
--
wizmark