Start with January 1st, 2011 Generate Series 0 ~ 200
Add (Series# * 7) Days to January 1st := CheckDate Filter where day(CheckDate) <= 7 Filter where CheckDate <= December 31st 2013 David J. From: [email protected] [mailto:[email protected]] On Behalf Of Alex - Sent: Wednesday, May 11, 2011 11:22 AM To: [email protected] Subject: [GENERAL] Query to return every 1st Sat of a month between two dates Hi, is there an easy way to return the date of every first Saturday of a month in a data range i.e. 2011-2013 Any help would be appreciated Thanks Alex
