Hi guys,
I hope you can help. I use excel to retrieve information from Synergy through ODBC. I have several sheets for each day of the month. What I do at the begining of every month is to edit every query for every day of the month and update the retrieval date and times. It is quite tedious. I've been doing it for 2 years and I would like to know if there any macro/script that can help me have the dates entered dynamically or with little user interaction. Here is the SELECT statement from the query ran 

Please Login or Register  to view this content.
Thanks in advanced,

JP