By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,127 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

Date Entry - Displayed as Month in PivotTable

P: 5
I have a table in which a "short Date" is entered. When I make a pivot table out of this table I want just the Month be displayed. How can this be donne?

PivotTable

Person Date
A January = 12/01/08
B January = 16/01/08
C February = 01/02/08
... ....


Can the entry in the table be viewed or entered just as a month? without using a txt field! or an other table where each month has a key

Key Month
01 January
02 February

The point is that I still want to keep the option to make calculations based on the Date.

Thanx in advance for your help
Feb 13 '08 #1
Share this Question
Share on Google+
2 Replies


cori25
P: 83
If you want the short date converted into just the month, you will have to do this in access.

1.) You will need to make the adjustment in the query that is being pulled into excel

2.) In the query, lets say that your date field is called "Short Date". This is how you can fix the problem.

Date:Format([Short Date], "mmm-yy")

This will give you the following result, Feb-08.

3.) Next, re-create the pivot table now using the data from the query where you have just changed the format of the date. This will allow you to have a more desirable appearance and not have to worry about faulty data.

Let me know if this helps
Feb 13 '08 #2

P: 5
It works!

Thx very much
Feb 14 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.