I run a series of queries at the beginning of each month to pull transactions from the previous month. Currently I am setting the date range for the julian dates. I would like to automate this series of queries and need a way to automate the data selection criteria so it will automatically pull the previous months information.
Is there any way to do this? I have a date conversion file that give me access to a month name or a month number. Watch out for January!
November 5, 2009 4:09 PM
November 27, 2009 10:26 AM