Hi everyone,

I am creating a pivot table and need to only show data that is greater
than todays date.
I have tried the following:

Column to filter.
Only include rows where
Date is greater than =today()

This doesnt work, however i am unsure if this isn't working because
the format the date is in is not showing as a date or I am writing the
the above incorrectly.

If =today() should work is there a way I can change the date?
Currently once I have created the report the dates show as
2007/03/12 which I then have to replace / with . and then vice versa
to enable me to format the cell as a date - this could be an internal
problem how the data is set up.

Any advice would be a great help.

Thanks all