Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 608
  • Last Modified:

Date Format to show date as January, 14, 2014

The user has requested that on certain documents created from our application, the date (for example 01/14/14) be shown in the format:

January, 14 2014

I am currently using the 'Long Date' format which show '01/14/14' as

Tuesday January, 14 2014.

What is the date format to present dates in the requested format.
0
mlcktmguy
Asked:
mlcktmguy
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use this format instead:

"mmmm, dd yyyy"

"mmmm" tells Access to show the full Month Name (like "March" instead of "Mar")

"dd" tells Access to show the day of the month with a leading 0 as neded

"yyyy" tells Access to show the full 4 digit year.

See this page for more information: http://office.microsoft.com/en-us/access-help/format-the-date-and-time-field-in-access-HA010341474.aspx
0
 
hnasrCommented:
Adding to Scott McDaniel's comment"

General format, try it in immediate window.

?Format(now(),"dddd mmmm, dd yyyy")
Tuesday January, 14 2014

?Format(now(),"mmmm, dd yyyy")
January, 14 2014
0
 
mlcktmguyAuthor Commented:
Thank You
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now