[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access Format Date

Posted on 2014-07-15
2
Medium Priority
?
339 Views
Last Modified: 2014-07-17
Hi,

I have this syntax in a crosstab ACCESS query

Format([Date],"mmm")

That returns Jan Feb Mar etc

I need two variations of this Syntax, one which returns Jan 13 Feb 14, and one that returns Jan 14 Feb 14 etc

Many thanks
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 12

Accepted Solution

by:
Nathan Riley earned 2000 total points
ID: 40196993
Are you looking for the 3 letters of the month and the day?  If so here you go:
Format([Date],"mmm dd")

Open in new window


Or 3 letters of the month then the year?  If so here you go:
Format([Date],"mmm yy")

Open in new window

0
 

Author Closing Comment

by:Seamus2626
ID: 40201469
Thanks!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

865 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question