Pivot date grouping
 

I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please

When you get the data from the query, the dates may be imported as text,
which would prevent them from being grouped. There are instructions here
for converting the text dates to real dates:

http://www.contextures.com/xlDataEntry03.html

sue wrote:
I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Suggestions will vary depending on version. Please provide more info. |:)

"sue" wrote:

I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please

Hi

I am working with office 2003 professional- The date is formatted as
*14/03/2001 however the pivot table does not seem to reconize this as a date
-

"CyberTaz" wrote:

Suggestions will vary depending on version. Please provide more info. |:)

"sue" wrote:

I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please

Hi thankyou,
the date is formatted as *14/03/2001, it appears to be reconized as a date
for everything but the pivot table.

"Debra Dalgleish" wrote:

When you get the data from the query, the dates may be imported as text,
which would prevent them from being grouped. There are instructions here
for converting the text dates to real dates:

http://www.contextures.com/xlDataEntry03.html

sue wrote:
I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html