Long Date format without day of the week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candice - 20 May 2008 18:40 GMT

How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)? The
closest I can find is the Long Date format (ie. Tuesday, May 20, 2008), which
includes the day of the week. How can I exclude the day from the format?

What input mask would reflect the same date format?

I use this date field with Mail Merge in MSWord and need the date to import
as indicated above.

Signature

Candice

Reply to this Message

Douglas J. Steele - 20 May 2008 18:48 GMT

You're not limited strictly to the named formats. Set your format to:

mmmm dd, yyyy

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)?
> The
[quoted text clipped - 7 lines]
> import
> as indicated above.

Reply to this Message

Jerry Whittle - 20 May 2008 19:02 GMT

First off the format has nothing, absolutely nothing with how date and time
data is stored in an Access database. Actually it's stored as a number.

For example May, 20 2008 is actually stored as 39588.

5/20/2008 12:55:23 PM is stored as 39588.5384606481.

Format is how that number is displayed. Therefore an input mask for a
Date/Time field would make no difference in how the data is displayed short
of requiring or preventing the time from being entered.

In a query you could use something like below to display the date as you wish.
TheDate: Format([TheDateField], "MMMM, DD YYYY")

In a form's field the format would look like so:
mmmm", "dd yyyy

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)? The
> closest I can find is the Long Date format (ie. Tuesday, May 20, 2008), which
[quoted text clipped - 4 lines]
> I use this date field with Mail Merge in MSWord and need the date to import
> as indicated above.

Reply to this Message

Chris O'C - 20 May 2008 19:09 GMT

If you're using a query for your mail merge, use the format function in one
of the columns in the query grid. Example:

BDay: Format(Birthday, "mmmm dd, yyyy")

In SQL View:

SELECT FName, LName, Format(Birthday, "mmmm dd, yyyy") AS BDay
FROM tblEmps;

Chris
Microsoft MVP

>How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)? The
>closest I can find is the Long Date format (ie. Tuesday, May 20, 2008), which
[quoted text clipped - 4 lines]
>I use this date field with Mail Merge in MSWord and need the date to import
>as indicated above.

Reply to this Message

Rate this thread: