Select dates before today

Is there not a filter in the Pivot table that does this for you?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I have just tested the upload functionality of the site and it works perfectly. Did you follow my instructions for uploading files? We want all files loaded to the site and not emailed as that prevents others from getting the benefit of the solution or the opportunity to help.

There is a file size limitation of 1000kb. Is your file bigger? If so, shrink it. We only need a representative sample. Not the entire file.

See if this works,

Please Login or Register  to view this content.

Hi

It looks as though you are querying external data, so why not simply amend the SQL query with a WHERE clause to only return dates prior to today?

I am not sure, I tested it again and it worked okay for me.