G
Guest
I have created 2 pivot tables in an excel workbook.
1. The first pivot table brings in values from midnight to 6am.
2. The second pivot table brings in values from the previous 5 days.
My question is how do i state the [Date] criteria in Microsoft Query to
include the last 5 days but not today?
Right now I have a field called [Date] and the criteria is set as;
[>=getdate()-5]
this works, but i do not want today's values. Any ideas?
1. The first pivot table brings in values from midnight to 6am.
2. The second pivot table brings in values from the previous 5 days.
My question is how do i state the [Date] criteria in Microsoft Query to
include the last 5 days but not today?
Right now I have a field called [Date] and the criteria is set as;
[>=getdate()-5]
this works, but i do not want today's values. Any ideas?