I make a pivot table and the dates cannot be format as <date-month-year>, in fact the date cannot be in a form that has the year in it. Although the table that pivot table is built is correct formated, see below. How can I have the dates without before dates and after dates and the year appeared in the filter. The data base table is correct formated. How can amend the pivot table?