I am trying to create a table or timechart that tracks averages for an event from the 3rd Tuesday of every month to the 3rd Monday in the following month (on a reoccurring basis). For example I want the output to look like:
Time Range Average 1/17/12-2/20/12 14.8 2/21/12-3/19/12 15.3
Can someone please help me figure out how to write this query? Thank you for all of your help.
Good luck! BTW, you realize that if you run this each month, some days will get skipped. Also, you might want to change the second line from "-2mon@min" to "-1mon@mon", depending on when you run the search each month.
answered 18 Mar '12, 01:32