Date Issue In Pivot Table

[tomohawk]

I have a set of data and I use pivot tables to analyse.

The column header is Month.

I've added February data but when I refresh the pivot table I get the "Jan" and "Feb" columns (But with additional (min/max) columns. When I unselect the ">" or "<", I lose data.

Also, when I remove date from the pivot table column and add it back, I do not get the Date/Year/Month option.

Tommy