How are you entering the time?
=Date() will set the time as midnight, time is 0:00 or 12:00 AM
=Now() will include the current time.
Bob Peterson
"Never look back unless you are planning to go that way."
― Henry David Thoreau
merry Christmas and a happy New Year!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of saigonf7q5@yahoo.com
Sent: Monday, December 23, 2013 10:08 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How do I format a Date/Time field to display the actual time like 12/04/2013 11:20 AM instead of 12/04/2013 12:00:00 AM
Good morning
My table has a date/time field.In the Field Properties section, I set the format as mm/dd/yyyy hh:mm:ss AM/PM. What caused the time section of the DateTime field displays the time as 12:00:00 AM instead of the actual time?
Thank you
Phucon
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar