Date Entry - Displayed as Month in PivotTable

[Tommaccoy]

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

[cori25]

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

[Tommaccoy]

It works!

Thx very much