Losing time information in Pivot Table

G

genisse05

Whenever I drop my date field into the row area of the pivot table it drops
the minutes from my date. It ends up looking like 4/12/2008 16:nn. I do not
know why it is placing the (nn) for the minutes.

Bea
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to return a 12 hour time format without the AM in an Access query 2
SUM & OFFSET & PIVOT TABLE?? 0
SQL Date Headaches 23
VLOOKUP a Pivot Table Filter 0
Pivot tables in access 2003 0
Slicers and Calculated Items in Pivot Table 2
Pivot Table Items 0
Import problem into SQL Server 2005 linked table 1

Top