Changing the date range parameters in MS Query

[Bomarzo]

Hi,

I have set up a pivot table that uses an external data source, the data in the pivot only reflects one month.

At the start of each months if I wan the pivot tables to update with the new data I have go in to MS Query and change the date range parameters. Is there anyway, vba or otherwise, that I can easily change the date range parameters in ms query each month?

Thanks