ACCESS FEED: Re: RE: [MS_AccessPros] How do I format a Date/Time field to display the actual time…

Senin, 23 Desember 2013

Re: RE: [MS_AccessPros] How do I format a Date/Time field to display the actual time…

Phucon, you are using the Calendar Control and picking up ONLY a date. The time is Zero or 12:00 am. Try adding in the current Time back to it.

7ony

Sent from Yahoo Mail on Android

From: Duane Hookom <duanehookom@hotmail.com>;
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>;
Subject: RE: [MS_AccessPros] How do I format a Date/Time field to display the actual time…
Sent: Mon, Dec 23, 2013 8:12:05 PM

Phucon,
Where are you viewing the NoteDt? Form, table, report, ...?
If in a form, what is the format of the text box?

What do you see if you type ? Now() into the debug/immediate window (press Ctrl+G)

Duane Hookom MVP
MS Access

________________________________

> From: saigonf7q5@yahoo.com
>
> I have been having trouble with the REPLY button or link on this web
> page. There's no response when I clicked on it and it displays Error On
> Page at the bottom left corner. So I reply the messages by using the
> NEW TOPIC button. I am sorry for any inconvenient this may cause.
>
> Thank you all. Originally, the format in the table's field property
> was set as mm/dd/yyyy hh:nn AM/PM.
>
> The date then was entered by selected from a calendar through an
> unbound form which's shown as below:
>
> With rs
> .AddNew
> !Sid = Me.txtSID
> !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM"))
> !Note = Me.txtNote
> .Update
> .Close
> End With
>
> But the time portion of the date was incorrect 12/23/2013 12:00 AM.
>
> Now I changed the line of code from
>
> !NoteDt = Format(Me.txtNoteDt, "mm/dd/yyyy hh:nn AM/PM") to !NoteDt = Now()
>
> With rs
> .AddNew
> !Sid = Me.txtSID
> !NoteDt = Now()
> !Note = Me.txtNote
> .Update
> .Close
> End With
>
> This displays the date and time correctly ONLY when the selected date
> is a current date. However, If the date is going to be in the past e.g.
> 11/23/2013, then only the time portion is correct, but the date becomes
> a current date 12/23/2013 2:03:56 PM, which is incorrect. ???
>
> Phucon