Date format changing

you should be able to format that field as a date - not sure why the format is changing like that
perhaps you attach a sample here for us to see

Here's the raw data:

Please Login or Register  to view this content.

here's the pivot table:

Please Login or Register  to view this content.

you should be able to format that field within the pivot table
click on the field
field settings
Number button
should allow a format to a date format

I would if I could. The only thing in the "WorkDate" fields is "Jun"--no day or year.

can you attach a cut down version of the data and pivot table ?

Please see post #3

thats not the actual spreadsheet is it
so we can have a play

Here's the complete rows:

Please Login or Register  to view this content.

thanks but i wanted it attached as a spreadsheet so I can actually manipulate in a pivot table

hope this helps

ProcessRouteParam.xlsm

click on workdate in the pivot report - cell E4
and then click on ungroup
and it changes to the correct format

its been grouped in the pivot table to show months and between a range of dates - if you click on the filter, you will see > and <

OK , not sure I know enough about pivot tables to combine fields into 1 dropdown