Date Time Field not displaying Date and Time

webmeister · January 30th, 2011, 09:21 PM

in my tblTestSession I defined tsSession as Date/Time and can not get it to display both the date and time.

I had copied my data from Excel where it shows both the date and time (i.e. 1/21/2011 12:01:00 AM)

In design view i have the format for the tsSession field as mmdd/yyyy; hh:nn

Please assist. Thank you.

Code:

 
 
 
tblTestSession
tsID    ttTestType tsSeats tsSession
551       D                    01/21/2011

HiTechCoach · January 31st, 2011, 12:48 AM

Try this:
mm/dd/yyyy hh:nn

HiTechCoach · January 31st, 2011, 12:49 AM

Also try:

or

mm/dd/yyyy hh:nn AM/PM

or

"Long Date"