Senin, 23 Desember 2013

RE: [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

 

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)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar