Yep. Boy does this one get you if you do < > selection criteria! The weird thing is that I've gotten different result sets in an interactive query than in VBA – but then again, as time moves forward, so does that < > business. I only use the now() if I explicitly WANT the time.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robert Peterson
Sent: Monday, December 23, 2013 8:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar