Displaying time without seconds

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wmdmurphy - 06 Apr 2008 19:20 GMT

In a form control I would like to display the date and time in this format
without seconds:

mm/dd/yy hh:mm PM

However, general date and time does include the seconds. Is there a way to
customize the display format to omit the seconds?

Bill

Reply to this Message

Marshall Barton - 06 Apr 2008 20:22 GMT

>In a form control I would like to display the date and time in this format
>without seconds:
[quoted text clipped - 3 lines]
>However, general date and time does include the seconds. Is there a way to
>customize the display format to omit the seconds?

Use a custom format like:

mm/dd/yy hh:nn AM/PM

See Help on "Format Property" for details on xreating custom
formats.

Signature

Marsh
MVP [MS Access]

Reply to this Message

fredg - 06 Apr 2008 20:27 GMT

> In a form control I would like to display the date and time in this format
> without seconds:
[quoted text clipped - 5 lines]
>
> Bill

You're not limited to the built-in formats.
On the Format property line of the control on the form, write:

mm/dd/yy hh:nn AM/PM

notice the "n" designates minutes, "m" designates months.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message